library(readr)
library(dplyr)
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
library(devtools)
## Loading required package: usethis
library(coronavirus)
library(ggplot2)
library(tidyr)
library(plotly) # To make graphs interactive
## 
## Attaching package: 'plotly'
## The following object is masked from 'package:ggplot2':
## 
##     last_plot
## The following object is masked from 'package:stats':
## 
##     filter
## The following object is masked from 'package:graphics':
## 
##     layout
library(leaflet) # to plot dynamic map
library(purrr)

# Use this commands to load coronavirus package from github
# install.packages("devtools")
# devtools::install_github("RamiKrispin/coronavirus")

# Run this statement individually to update dataset and to refresh data, restart the session
update_dataset()
## Updates are available on the coronavirus Dev version, do you want to update? n/Y
# Checking the output
covid <- coronavirus
head(covid)
##         date province     country      lat     long      type cases
## 1 2020-01-22          Afghanistan 33.93911 67.70995 confirmed     0
## 2 2020-01-23          Afghanistan 33.93911 67.70995 confirmed     0
## 3 2020-01-24          Afghanistan 33.93911 67.70995 confirmed     0
## 4 2020-01-25          Afghanistan 33.93911 67.70995 confirmed     0
## 5 2020-01-26          Afghanistan 33.93911 67.70995 confirmed     0
## 6 2020-01-27          Afghanistan 33.93911 67.70995 confirmed     0
tail(covid)
##              date province country     lat     long      type cases
## 193105 2020-09-18 Zhejiang   China 29.1832 120.0934 recovered     0
## 193106 2020-09-19 Zhejiang   China 29.1832 120.0934 recovered     0
## 193107 2020-09-20 Zhejiang   China 29.1832 120.0934 recovered     0
## 193108 2020-09-21 Zhejiang   China 29.1832 120.0934 recovered     0
## 193109 2020-09-22 Zhejiang   China 29.1832 120.0934 recovered     0
## 193110 2020-09-23 Zhejiang   China 29.1832 120.0934 recovered     0
# checking for total null values
sapply(covid, function(x) sum(is.na(x)))
##     date province  country      lat     long     type    cases 
##        0        0        0        0        0        0        0
# summary details
summary(covid)
##       date              province           country               lat         
##  Min.   :2020-01-22   Length:193110      Length:193110      Min.   :-51.796  
##  1st Qu.:2020-03-23   Class :character   Class :character   1st Qu.:  6.611  
##  Median :2020-05-23   Mode  :character   Mode  :character   Median : 22.167  
##  Mean   :2020-05-23                                         Mean   : 20.677  
##  3rd Qu.:2020-07-24                                         3rd Qu.: 40.182  
##  Max.   :2020-09-23                                         Max.   : 71.707  
##       long             type               cases       
##  Min.   :-135.00   Length:193110      Min.   :-16298  
##  1st Qu.: -12.89   Class :character   1st Qu.:     0  
##  Median :  21.75   Mode  :character   Median :     0  
##  Mean   :  24.49                      Mean   :   283  
##  3rd Qu.:  80.77                      3rd Qu.:     9  
##  Max.   : 178.06                      Max.   :140050
# total days with reported cases numbers (+ve and -ve)
covid %>% summarise(n = n())
##        n
## 1 193110
# total days with negative numbers reported
count <- covid[covid$cases < 0, ]
count %>% summarise(total_negative_cases = n())
##   total_negative_cases
## 1                  346
# some countries report tests performed which are positive as (confirmed) and if negative than confirmed are 0.
# while some countries report both positive and negative test results in all type of cases. So those negative values should be reported as 0.
# Moreover, the percentage of negative values is 0.18% (346/191540)(checked as of 24th September). 
# Therefore, we decide to set those negative reported results as 0. 
covid$cases[covid$cases < 0] <- 0

# dropping province column
covid <- select(covid, -matches("province"))
head(covid)
##         date     country      lat     long      type cases
## 1 2020-01-22 Afghanistan 33.93911 67.70995 confirmed     0
## 2 2020-01-23 Afghanistan 33.93911 67.70995 confirmed     0
## 3 2020-01-24 Afghanistan 33.93911 67.70995 confirmed     0
## 4 2020-01-25 Afghanistan 33.93911 67.70995 confirmed     0
## 5 2020-01-26 Afghanistan 33.93911 67.70995 confirmed     0
## 6 2020-01-27 Afghanistan 33.93911 67.70995 confirmed     0
# changing column data types to factor, numeric and integer
covid[, 2] <- sapply(covid[, 2], as.factor)
covid$lat <- as.numeric(covid$lat)
covid[, 4] <- sapply(covid[, 4], as.numeric)
covid$type <- as.factor(covid$type)

# checking the data types
sapply(covid, class)
##      date   country       lat      long      type     cases 
##    "Date"  "factor" "numeric" "numeric"  "factor" "numeric"
# Descriptive statistics grouped by type. Global
covid %>% group_by(type) %>% 
  summarise(Min = min(cases, na.rm = TRUE),
                                       Q1 = quantile(cases, probs = .25, na.rm = TRUE),
                                       Median = median(cases ,na.rim = TRUE),
                                       Q3 = quantile(cases, probs = .75, na.rm = TRUE),
                                       Max = max(cases, na.rm = TRUE),
                                       Mean = mean(cases, na.rm = TRUE),
                                       SD = sd(cases , na.rm = TRUE),
                                       InterquartileRange = IQR(cases, na.rm = TRUE),
                                       N = n(),
                                       Cases = sum(cases, na.rm = TRUE))
## # A tibble: 3 x 11
##   type    Min    Q1 Median    Q3    Max  Mean    SD InterquartileRa~     N
##   <fct> <dbl> <dbl>  <dbl> <dbl>  <dbl> <dbl> <dbl>            <dbl> <int>
## 1 conf~     0     0      1    49  97894 486.  3665.               49 65436
## 2 death     0     0      0     1   4143  14.9  103.                1 65436
## 3 reco~     0     0      0    17 140050 353.  3005.               17 62238
## # ... with 1 more variable: Cases <dbl>
# Descriptive statistics. 
covidAUS <- covid %>% filter(country == "Australia")

# sub setting data quarterly
covidAUS$quarter <- quarters(covidAUS$date)
subset(covidAUS, quarter=='Q1')
##            date   country      lat     long      type cases quarter
## 1    2020-01-22 Australia -35.4735 149.0124 confirmed     0      Q1
## 2    2020-01-23 Australia -35.4735 149.0124 confirmed     0      Q1
## 3    2020-01-24 Australia -35.4735 149.0124 confirmed     0      Q1
## 4    2020-01-25 Australia -35.4735 149.0124 confirmed     0      Q1
## 5    2020-01-26 Australia -35.4735 149.0124 confirmed     0      Q1
## 6    2020-01-27 Australia -35.4735 149.0124 confirmed     0      Q1
## 7    2020-01-28 Australia -35.4735 149.0124 confirmed     0      Q1
## 8    2020-01-29 Australia -35.4735 149.0124 confirmed     0      Q1
## 9    2020-01-30 Australia -35.4735 149.0124 confirmed     0      Q1
## 10   2020-01-31 Australia -35.4735 149.0124 confirmed     0      Q1
## 11   2020-02-01 Australia -35.4735 149.0124 confirmed     0      Q1
## 12   2020-02-02 Australia -35.4735 149.0124 confirmed     0      Q1
## 13   2020-02-03 Australia -35.4735 149.0124 confirmed     0      Q1
## 14   2020-02-04 Australia -35.4735 149.0124 confirmed     0      Q1
## 15   2020-02-05 Australia -35.4735 149.0124 confirmed     0      Q1
## 16   2020-02-06 Australia -35.4735 149.0124 confirmed     0      Q1
## 17   2020-02-07 Australia -35.4735 149.0124 confirmed     0      Q1
## 18   2020-02-08 Australia -35.4735 149.0124 confirmed     0      Q1
## 19   2020-02-09 Australia -35.4735 149.0124 confirmed     0      Q1
## 20   2020-02-10 Australia -35.4735 149.0124 confirmed     0      Q1
## 21   2020-02-11 Australia -35.4735 149.0124 confirmed     0      Q1
## 22   2020-02-12 Australia -35.4735 149.0124 confirmed     0      Q1
## 23   2020-02-13 Australia -35.4735 149.0124 confirmed     0      Q1
## 24   2020-02-14 Australia -35.4735 149.0124 confirmed     0      Q1
## 25   2020-02-15 Australia -35.4735 149.0124 confirmed     0      Q1
## 26   2020-02-16 Australia -35.4735 149.0124 confirmed     0      Q1
## 27   2020-02-17 Australia -35.4735 149.0124 confirmed     0      Q1
## 28   2020-02-18 Australia -35.4735 149.0124 confirmed     0      Q1
## 29   2020-02-19 Australia -35.4735 149.0124 confirmed     0      Q1
## 30   2020-02-20 Australia -35.4735 149.0124 confirmed     0      Q1
## 31   2020-02-21 Australia -35.4735 149.0124 confirmed     0      Q1
## 32   2020-02-22 Australia -35.4735 149.0124 confirmed     0      Q1
## 33   2020-02-23 Australia -35.4735 149.0124 confirmed     0      Q1
## 34   2020-02-24 Australia -35.4735 149.0124 confirmed     0      Q1
## 35   2020-02-25 Australia -35.4735 149.0124 confirmed     0      Q1
## 36   2020-02-26 Australia -35.4735 149.0124 confirmed     0      Q1
## 37   2020-02-27 Australia -35.4735 149.0124 confirmed     0      Q1
## 38   2020-02-28 Australia -35.4735 149.0124 confirmed     0      Q1
## 39   2020-02-29 Australia -35.4735 149.0124 confirmed     0      Q1
## 40   2020-03-01 Australia -35.4735 149.0124 confirmed     0      Q1
## 41   2020-03-02 Australia -35.4735 149.0124 confirmed     0      Q1
## 42   2020-03-03 Australia -35.4735 149.0124 confirmed     0      Q1
## 43   2020-03-04 Australia -35.4735 149.0124 confirmed     0      Q1
## 44   2020-03-05 Australia -35.4735 149.0124 confirmed     0      Q1
## 45   2020-03-06 Australia -35.4735 149.0124 confirmed     0      Q1
## 46   2020-03-07 Australia -35.4735 149.0124 confirmed     0      Q1
## 47   2020-03-08 Australia -35.4735 149.0124 confirmed     0      Q1
## 48   2020-03-09 Australia -35.4735 149.0124 confirmed     0      Q1
## 49   2020-03-10 Australia -35.4735 149.0124 confirmed     0      Q1
## 50   2020-03-11 Australia -35.4735 149.0124 confirmed     0      Q1
## 51   2020-03-12 Australia -35.4735 149.0124 confirmed     0      Q1
## 52   2020-03-13 Australia -35.4735 149.0124 confirmed     1      Q1
## 53   2020-03-14 Australia -35.4735 149.0124 confirmed     0      Q1
## 54   2020-03-15 Australia -35.4735 149.0124 confirmed     0      Q1
## 55   2020-03-16 Australia -35.4735 149.0124 confirmed     1      Q1
## 56   2020-03-17 Australia -35.4735 149.0124 confirmed     0      Q1
## 57   2020-03-18 Australia -35.4735 149.0124 confirmed     1      Q1
## 58   2020-03-19 Australia -35.4735 149.0124 confirmed     1      Q1
## 59   2020-03-20 Australia -35.4735 149.0124 confirmed     2      Q1
## 60   2020-03-21 Australia -35.4735 149.0124 confirmed     3      Q1
## 61   2020-03-22 Australia -35.4735 149.0124 confirmed    10      Q1
## 62   2020-03-23 Australia -35.4735 149.0124 confirmed    13      Q1
## 63   2020-03-24 Australia -35.4735 149.0124 confirmed     7      Q1
## 64   2020-03-25 Australia -35.4735 149.0124 confirmed     0      Q1
## 65   2020-03-26 Australia -35.4735 149.0124 confirmed    14      Q1
## 66   2020-03-27 Australia -35.4735 149.0124 confirmed     9      Q1
## 67   2020-03-28 Australia -35.4735 149.0124 confirmed     9      Q1
## 68   2020-03-29 Australia -35.4735 149.0124 confirmed     6      Q1
## 69   2020-03-30 Australia -35.4735 149.0124 confirmed     1      Q1
## 70   2020-03-31 Australia -35.4735 149.0124 confirmed     2      Q1
## 247  2020-01-22 Australia -33.8688 151.2093 confirmed     0      Q1
## 248  2020-01-23 Australia -33.8688 151.2093 confirmed     0      Q1
## 249  2020-01-24 Australia -33.8688 151.2093 confirmed     0      Q1
## 250  2020-01-25 Australia -33.8688 151.2093 confirmed     0      Q1
## 251  2020-01-26 Australia -33.8688 151.2093 confirmed     3      Q1
## 252  2020-01-27 Australia -33.8688 151.2093 confirmed     1      Q1
## 253  2020-01-28 Australia -33.8688 151.2093 confirmed     0      Q1
## 254  2020-01-29 Australia -33.8688 151.2093 confirmed     0      Q1
## 255  2020-01-30 Australia -33.8688 151.2093 confirmed     0      Q1
## 256  2020-01-31 Australia -33.8688 151.2093 confirmed     0      Q1
## 257  2020-02-01 Australia -33.8688 151.2093 confirmed     0      Q1
## 258  2020-02-02 Australia -33.8688 151.2093 confirmed     0      Q1
## 259  2020-02-03 Australia -33.8688 151.2093 confirmed     0      Q1
## 260  2020-02-04 Australia -33.8688 151.2093 confirmed     0      Q1
## 261  2020-02-05 Australia -33.8688 151.2093 confirmed     0      Q1
## 262  2020-02-06 Australia -33.8688 151.2093 confirmed     0      Q1
## 263  2020-02-07 Australia -33.8688 151.2093 confirmed     0      Q1
## 264  2020-02-08 Australia -33.8688 151.2093 confirmed     0      Q1
## 265  2020-02-09 Australia -33.8688 151.2093 confirmed     0      Q1
## 266  2020-02-10 Australia -33.8688 151.2093 confirmed     0      Q1
## 267  2020-02-11 Australia -33.8688 151.2093 confirmed     0      Q1
## 268  2020-02-12 Australia -33.8688 151.2093 confirmed     0      Q1
## 269  2020-02-13 Australia -33.8688 151.2093 confirmed     0      Q1
## 270  2020-02-14 Australia -33.8688 151.2093 confirmed     0      Q1
## 271  2020-02-15 Australia -33.8688 151.2093 confirmed     0      Q1
## 272  2020-02-16 Australia -33.8688 151.2093 confirmed     0      Q1
## 273  2020-02-17 Australia -33.8688 151.2093 confirmed     0      Q1
## 274  2020-02-18 Australia -33.8688 151.2093 confirmed     0      Q1
## 275  2020-02-19 Australia -33.8688 151.2093 confirmed     0      Q1
## 276  2020-02-20 Australia -33.8688 151.2093 confirmed     0      Q1
## 277  2020-02-21 Australia -33.8688 151.2093 confirmed     0      Q1
## 278  2020-02-22 Australia -33.8688 151.2093 confirmed     0      Q1
## 279  2020-02-23 Australia -33.8688 151.2093 confirmed     0      Q1
## 280  2020-02-24 Australia -33.8688 151.2093 confirmed     0      Q1
## 281  2020-02-25 Australia -33.8688 151.2093 confirmed     0      Q1
## 282  2020-02-26 Australia -33.8688 151.2093 confirmed     0      Q1
## 283  2020-02-27 Australia -33.8688 151.2093 confirmed     0      Q1
## 284  2020-02-28 Australia -33.8688 151.2093 confirmed     0      Q1
## 285  2020-02-29 Australia -33.8688 151.2093 confirmed     0      Q1
## 286  2020-03-01 Australia -33.8688 151.2093 confirmed     2      Q1
## 287  2020-03-02 Australia -33.8688 151.2093 confirmed     0      Q1
## 288  2020-03-03 Australia -33.8688 151.2093 confirmed     7      Q1
## 289  2020-03-04 Australia -33.8688 151.2093 confirmed     9      Q1
## 290  2020-03-05 Australia -33.8688 151.2093 confirmed     0      Q1
## 291  2020-03-06 Australia -33.8688 151.2093 confirmed     4      Q1
## 292  2020-03-07 Australia -33.8688 151.2093 confirmed     2      Q1
## 293  2020-03-08 Australia -33.8688 151.2093 confirmed    10      Q1
## 294  2020-03-09 Australia -33.8688 151.2093 confirmed    10      Q1
## 295  2020-03-10 Australia -33.8688 151.2093 confirmed     7      Q1
## 296  2020-03-11 Australia -33.8688 151.2093 confirmed    10      Q1
## 297  2020-03-12 Australia -33.8688 151.2093 confirmed     0      Q1
## 298  2020-03-13 Australia -33.8688 151.2093 confirmed    27      Q1
## 299  2020-03-14 Australia -33.8688 151.2093 confirmed    20      Q1
## 300  2020-03-15 Australia -33.8688 151.2093 confirmed    22      Q1
## 301  2020-03-16 Australia -33.8688 151.2093 confirmed    37      Q1
## 302  2020-03-17 Australia -33.8688 151.2093 confirmed    39      Q1
## 303  2020-03-18 Australia -33.8688 151.2093 confirmed    57      Q1
## 304  2020-03-19 Australia -33.8688 151.2093 confirmed    40      Q1
## 305  2020-03-20 Australia -33.8688 151.2093 confirmed    46      Q1
## 306  2020-03-21 Australia -33.8688 151.2093 confirmed    83      Q1
## 307  2020-03-22 Australia -33.8688 151.2093 confirmed   233      Q1
## 308  2020-03-23 Australia -33.8688 151.2093 confirmed     0      Q1
## 309  2020-03-24 Australia -33.8688 151.2093 confirmed   149      Q1
## 310  2020-03-25 Australia -33.8688 151.2093 confirmed   211      Q1
## 311  2020-03-26 Australia -33.8688 151.2093 confirmed   190      Q1
## 312  2020-03-27 Australia -33.8688 151.2093 confirmed   186      Q1
## 313  2020-03-28 Australia -33.8688 151.2093 confirmed   212      Q1
## 314  2020-03-29 Australia -33.8688 151.2093 confirmed   174      Q1
## 315  2020-03-30 Australia -33.8688 151.2093 confirmed   241      Q1
## 316  2020-03-31 Australia -33.8688 151.2093 confirmed     0      Q1
## 493  2020-01-22 Australia -12.4634 130.8456 confirmed     0      Q1
## 494  2020-01-23 Australia -12.4634 130.8456 confirmed     0      Q1
## 495  2020-01-24 Australia -12.4634 130.8456 confirmed     0      Q1
## 496  2020-01-25 Australia -12.4634 130.8456 confirmed     0      Q1
## 497  2020-01-26 Australia -12.4634 130.8456 confirmed     0      Q1
## 498  2020-01-27 Australia -12.4634 130.8456 confirmed     0      Q1
## 499  2020-01-28 Australia -12.4634 130.8456 confirmed     0      Q1
## 500  2020-01-29 Australia -12.4634 130.8456 confirmed     0      Q1
## 501  2020-01-30 Australia -12.4634 130.8456 confirmed     0      Q1
## 502  2020-01-31 Australia -12.4634 130.8456 confirmed     0      Q1
## 503  2020-02-01 Australia -12.4634 130.8456 confirmed     0      Q1
## 504  2020-02-02 Australia -12.4634 130.8456 confirmed     0      Q1
## 505  2020-02-03 Australia -12.4634 130.8456 confirmed     0      Q1
## 506  2020-02-04 Australia -12.4634 130.8456 confirmed     0      Q1
## 507  2020-02-05 Australia -12.4634 130.8456 confirmed     0      Q1
## 508  2020-02-06 Australia -12.4634 130.8456 confirmed     0      Q1
## 509  2020-02-07 Australia -12.4634 130.8456 confirmed     0      Q1
## 510  2020-02-08 Australia -12.4634 130.8456 confirmed     0      Q1
## 511  2020-02-09 Australia -12.4634 130.8456 confirmed     0      Q1
## 512  2020-02-10 Australia -12.4634 130.8456 confirmed     0      Q1
## 513  2020-02-11 Australia -12.4634 130.8456 confirmed     0      Q1
## 514  2020-02-12 Australia -12.4634 130.8456 confirmed     0      Q1
## 515  2020-02-13 Australia -12.4634 130.8456 confirmed     0      Q1
## 516  2020-02-14 Australia -12.4634 130.8456 confirmed     0      Q1
## 517  2020-02-15 Australia -12.4634 130.8456 confirmed     0      Q1
## 518  2020-02-16 Australia -12.4634 130.8456 confirmed     0      Q1
## 519  2020-02-17 Australia -12.4634 130.8456 confirmed     0      Q1
## 520  2020-02-18 Australia -12.4634 130.8456 confirmed     0      Q1
## 521  2020-02-19 Australia -12.4634 130.8456 confirmed     0      Q1
## 522  2020-02-20 Australia -12.4634 130.8456 confirmed     0      Q1
## 523  2020-02-21 Australia -12.4634 130.8456 confirmed     0      Q1
## 524  2020-02-22 Australia -12.4634 130.8456 confirmed     0      Q1
## 525  2020-02-23 Australia -12.4634 130.8456 confirmed     0      Q1
## 526  2020-02-24 Australia -12.4634 130.8456 confirmed     0      Q1
## 527  2020-02-25 Australia -12.4634 130.8456 confirmed     0      Q1
## 528  2020-02-26 Australia -12.4634 130.8456 confirmed     0      Q1
## 529  2020-02-27 Australia -12.4634 130.8456 confirmed     0      Q1
## 530  2020-02-28 Australia -12.4634 130.8456 confirmed     0      Q1
## 531  2020-02-29 Australia -12.4634 130.8456 confirmed     0      Q1
## 532  2020-03-01 Australia -12.4634 130.8456 confirmed     0      Q1
## 533  2020-03-02 Australia -12.4634 130.8456 confirmed     0      Q1
## 534  2020-03-03 Australia -12.4634 130.8456 confirmed     0      Q1
## 535  2020-03-04 Australia -12.4634 130.8456 confirmed     1      Q1
## 536  2020-03-05 Australia -12.4634 130.8456 confirmed     0      Q1
## 537  2020-03-06 Australia -12.4634 130.8456 confirmed     0      Q1
## 538  2020-03-07 Australia -12.4634 130.8456 confirmed     0      Q1
## 539  2020-03-08 Australia -12.4634 130.8456 confirmed     0      Q1
## 540  2020-03-09 Australia -12.4634 130.8456 confirmed     0      Q1
## 541  2020-03-10 Australia -12.4634 130.8456 confirmed     1      Q1
## 542  2020-03-11 Australia -12.4634 130.8456 confirmed     0      Q1
## 543  2020-03-12 Australia -12.4634 130.8456 confirmed     0      Q1
## 544  2020-03-13 Australia -12.4634 130.8456 confirmed     0      Q1
## 545  2020-03-14 Australia -12.4634 130.8456 confirmed     0      Q1
## 546  2020-03-15 Australia -12.4634 130.8456 confirmed     0      Q1
## 547  2020-03-16 Australia -12.4634 130.8456 confirmed     0      Q1
## 548  2020-03-17 Australia -12.4634 130.8456 confirmed     0      Q1
## 549  2020-03-18 Australia -12.4634 130.8456 confirmed     0      Q1
## 550  2020-03-19 Australia -12.4634 130.8456 confirmed     0      Q1
## 551  2020-03-20 Australia -12.4634 130.8456 confirmed     2      Q1
## 552  2020-03-21 Australia -12.4634 130.8456 confirmed     0      Q1
## 553  2020-03-22 Australia -12.4634 130.8456 confirmed     2      Q1
## 554  2020-03-23 Australia -12.4634 130.8456 confirmed     0      Q1
## 555  2020-03-24 Australia -12.4634 130.8456 confirmed     1      Q1
## 556  2020-03-25 Australia -12.4634 130.8456 confirmed     0      Q1
## 557  2020-03-26 Australia -12.4634 130.8456 confirmed     6      Q1
## 558  2020-03-27 Australia -12.4634 130.8456 confirmed     0      Q1
## 559  2020-03-28 Australia -12.4634 130.8456 confirmed     3      Q1
## 560  2020-03-29 Australia -12.4634 130.8456 confirmed     0      Q1
## 561  2020-03-30 Australia -12.4634 130.8456 confirmed     0      Q1
## 562  2020-03-31 Australia -12.4634 130.8456 confirmed     2      Q1
## 739  2020-01-22 Australia -27.4698 153.0251 confirmed     0      Q1
## 740  2020-01-23 Australia -27.4698 153.0251 confirmed     0      Q1
## 741  2020-01-24 Australia -27.4698 153.0251 confirmed     0      Q1
## 742  2020-01-25 Australia -27.4698 153.0251 confirmed     0      Q1
## 743  2020-01-26 Australia -27.4698 153.0251 confirmed     0      Q1
## 744  2020-01-27 Australia -27.4698 153.0251 confirmed     0      Q1
## 745  2020-01-28 Australia -27.4698 153.0251 confirmed     0      Q1
## 746  2020-01-29 Australia -27.4698 153.0251 confirmed     1      Q1
## 747  2020-01-30 Australia -27.4698 153.0251 confirmed     2      Q1
## 748  2020-01-31 Australia -27.4698 153.0251 confirmed     0      Q1
## 749  2020-02-01 Australia -27.4698 153.0251 confirmed     1      Q1
## 750  2020-02-02 Australia -27.4698 153.0251 confirmed     0      Q1
## 751  2020-02-03 Australia -27.4698 153.0251 confirmed     0      Q1
## 752  2020-02-04 Australia -27.4698 153.0251 confirmed     1      Q1
## 753  2020-02-05 Australia -27.4698 153.0251 confirmed     0      Q1
## 754  2020-02-06 Australia -27.4698 153.0251 confirmed     1      Q1
## 755  2020-02-07 Australia -27.4698 153.0251 confirmed     1      Q1
## 756  2020-02-08 Australia -27.4698 153.0251 confirmed     0      Q1
## 757  2020-02-09 Australia -27.4698 153.0251 confirmed     0      Q1
## 758  2020-02-10 Australia -27.4698 153.0251 confirmed     0      Q1
## 759  2020-02-11 Australia -27.4698 153.0251 confirmed     0      Q1
## 760  2020-02-12 Australia -27.4698 153.0251 confirmed     0      Q1
## 761  2020-02-13 Australia -27.4698 153.0251 confirmed     0      Q1
## 762  2020-02-14 Australia -27.4698 153.0251 confirmed     0      Q1
## 763  2020-02-15 Australia -27.4698 153.0251 confirmed     0      Q1
## 764  2020-02-16 Australia -27.4698 153.0251 confirmed     0      Q1
## 765  2020-02-17 Australia -27.4698 153.0251 confirmed     0      Q1
## 766  2020-02-18 Australia -27.4698 153.0251 confirmed     0      Q1
## 767  2020-02-19 Australia -27.4698 153.0251 confirmed     0      Q1
## 768  2020-02-20 Australia -27.4698 153.0251 confirmed     0      Q1
## 769  2020-02-21 Australia -27.4698 153.0251 confirmed     0      Q1
## 770  2020-02-22 Australia -27.4698 153.0251 confirmed     0      Q1
## 771  2020-02-23 Australia -27.4698 153.0251 confirmed     0      Q1
## 772  2020-02-24 Australia -27.4698 153.0251 confirmed     0      Q1
## 773  2020-02-25 Australia -27.4698 153.0251 confirmed     0      Q1
## 774  2020-02-26 Australia -27.4698 153.0251 confirmed     0      Q1
## 775  2020-02-27 Australia -27.4698 153.0251 confirmed     0      Q1
## 776  2020-02-28 Australia -27.4698 153.0251 confirmed     0      Q1
## 777  2020-02-29 Australia -27.4698 153.0251 confirmed     4      Q1
## 778  2020-03-01 Australia -27.4698 153.0251 confirmed     0      Q1
## 779  2020-03-02 Australia -27.4698 153.0251 confirmed     0      Q1
## 780  2020-03-03 Australia -27.4698 153.0251 confirmed     2      Q1
## 781  2020-03-04 Australia -27.4698 153.0251 confirmed     0      Q1
## 782  2020-03-05 Australia -27.4698 153.0251 confirmed     2      Q1
## 783  2020-03-06 Australia -27.4698 153.0251 confirmed     0      Q1
## 784  2020-03-07 Australia -27.4698 153.0251 confirmed     0      Q1
## 785  2020-03-08 Australia -27.4698 153.0251 confirmed     2      Q1
## 786  2020-03-09 Australia -27.4698 153.0251 confirmed     0      Q1
## 787  2020-03-10 Australia -27.4698 153.0251 confirmed     3      Q1
## 788  2020-03-11 Australia -27.4698 153.0251 confirmed     2      Q1
## 789  2020-03-12 Australia -27.4698 153.0251 confirmed     0      Q1
## 790  2020-03-13 Australia -27.4698 153.0251 confirmed    15      Q1
## 791  2020-03-14 Australia -27.4698 153.0251 confirmed    11      Q1
## 792  2020-03-15 Australia -27.4698 153.0251 confirmed    15      Q1
## 793  2020-03-16 Australia -27.4698 153.0251 confirmed     7      Q1
## 794  2020-03-17 Australia -27.4698 153.0251 confirmed    10      Q1
## 795  2020-03-18 Australia -27.4698 153.0251 confirmed    16      Q1
## 796  2020-03-19 Australia -27.4698 153.0251 confirmed    50      Q1
## 797  2020-03-20 Australia -27.4698 153.0251 confirmed    40      Q1
## 798  2020-03-21 Australia -27.4698 153.0251 confirmed    37      Q1
## 799  2020-03-22 Australia -27.4698 153.0251 confirmed    38      Q1
## 800  2020-03-23 Australia -27.4698 153.0251 confirmed    60      Q1
## 801  2020-03-24 Australia -27.4698 153.0251 confirmed    78      Q1
## 802  2020-03-25 Australia -27.4698 153.0251 confirmed    46      Q1
## 803  2020-03-26 Australia -27.4698 153.0251 confirmed    50      Q1
## 804  2020-03-27 Australia -27.4698 153.0251 confirmed    62      Q1
## 805  2020-03-28 Australia -27.4698 153.0251 confirmed    70      Q1
## 806  2020-03-29 Australia -27.4698 153.0251 confirmed    31      Q1
## 807  2020-03-30 Australia -27.4698 153.0251 confirmed    33      Q1
## 808  2020-03-31 Australia -27.4698 153.0251 confirmed    54      Q1
## 985  2020-01-22 Australia -34.9285 138.6007 confirmed     0      Q1
## 986  2020-01-23 Australia -34.9285 138.6007 confirmed     0      Q1
## 987  2020-01-24 Australia -34.9285 138.6007 confirmed     0      Q1
## 988  2020-01-25 Australia -34.9285 138.6007 confirmed     0      Q1
## 989  2020-01-26 Australia -34.9285 138.6007 confirmed     0      Q1
## 990  2020-01-27 Australia -34.9285 138.6007 confirmed     0      Q1
## 991  2020-01-28 Australia -34.9285 138.6007 confirmed     0      Q1
## 992  2020-01-29 Australia -34.9285 138.6007 confirmed     0      Q1
## 993  2020-01-30 Australia -34.9285 138.6007 confirmed     0      Q1
## 994  2020-01-31 Australia -34.9285 138.6007 confirmed     0      Q1
## 995  2020-02-01 Australia -34.9285 138.6007 confirmed     1      Q1
## 996  2020-02-02 Australia -34.9285 138.6007 confirmed     1      Q1
## 997  2020-02-03 Australia -34.9285 138.6007 confirmed     0      Q1
## 998  2020-02-04 Australia -34.9285 138.6007 confirmed     0      Q1
## 999  2020-02-05 Australia -34.9285 138.6007 confirmed     0      Q1
## 1000 2020-02-06 Australia -34.9285 138.6007 confirmed     0      Q1
## 1001 2020-02-07 Australia -34.9285 138.6007 confirmed     0      Q1
## 1002 2020-02-08 Australia -34.9285 138.6007 confirmed     0      Q1
## 1003 2020-02-09 Australia -34.9285 138.6007 confirmed     0      Q1
## 1004 2020-02-10 Australia -34.9285 138.6007 confirmed     0      Q1
## 1005 2020-02-11 Australia -34.9285 138.6007 confirmed     0      Q1
## 1006 2020-02-12 Australia -34.9285 138.6007 confirmed     0      Q1
## 1007 2020-02-13 Australia -34.9285 138.6007 confirmed     0      Q1
## 1008 2020-02-14 Australia -34.9285 138.6007 confirmed     0      Q1
## 1009 2020-02-15 Australia -34.9285 138.6007 confirmed     0      Q1
## 1010 2020-02-16 Australia -34.9285 138.6007 confirmed     0      Q1
## 1011 2020-02-17 Australia -34.9285 138.6007 confirmed     0      Q1
## 1012 2020-02-18 Australia -34.9285 138.6007 confirmed     0      Q1
## 1013 2020-02-19 Australia -34.9285 138.6007 confirmed     0      Q1
## 1014 2020-02-20 Australia -34.9285 138.6007 confirmed     0      Q1
## 1015 2020-02-21 Australia -34.9285 138.6007 confirmed     0      Q1
## 1016 2020-02-22 Australia -34.9285 138.6007 confirmed     0      Q1
## 1017 2020-02-23 Australia -34.9285 138.6007 confirmed     0      Q1
## 1018 2020-02-24 Australia -34.9285 138.6007 confirmed     0      Q1
## 1019 2020-02-25 Australia -34.9285 138.6007 confirmed     0      Q1
## 1020 2020-02-26 Australia -34.9285 138.6007 confirmed     0      Q1
## 1021 2020-02-27 Australia -34.9285 138.6007 confirmed     0      Q1
## 1022 2020-02-28 Australia -34.9285 138.6007 confirmed     0      Q1
## 1023 2020-02-29 Australia -34.9285 138.6007 confirmed     1      Q1
## 1024 2020-03-01 Australia -34.9285 138.6007 confirmed     0      Q1
## 1025 2020-03-02 Australia -34.9285 138.6007 confirmed     0      Q1
## 1026 2020-03-03 Australia -34.9285 138.6007 confirmed     0      Q1
## 1027 2020-03-04 Australia -34.9285 138.6007 confirmed     2      Q1
## 1028 2020-03-05 Australia -34.9285 138.6007 confirmed     0      Q1
## 1029 2020-03-06 Australia -34.9285 138.6007 confirmed     2      Q1
## 1030 2020-03-07 Australia -34.9285 138.6007 confirmed     0      Q1
## 1031 2020-03-08 Australia -34.9285 138.6007 confirmed     0      Q1
## 1032 2020-03-09 Australia -34.9285 138.6007 confirmed     0      Q1
## 1033 2020-03-10 Australia -34.9285 138.6007 confirmed     0      Q1
## 1034 2020-03-11 Australia -34.9285 138.6007 confirmed     2      Q1
## 1035 2020-03-12 Australia -34.9285 138.6007 confirmed     0      Q1
## 1036 2020-03-13 Australia -34.9285 138.6007 confirmed     7      Q1
## 1037 2020-03-14 Australia -34.9285 138.6007 confirmed     3      Q1
## 1038 2020-03-15 Australia -34.9285 138.6007 confirmed     1      Q1
## 1039 2020-03-16 Australia -34.9285 138.6007 confirmed     9      Q1
## 1040 2020-03-17 Australia -34.9285 138.6007 confirmed     0      Q1
## 1041 2020-03-18 Australia -34.9285 138.6007 confirmed     8      Q1
## 1042 2020-03-19 Australia -34.9285 138.6007 confirmed     5      Q1
## 1043 2020-03-20 Australia -34.9285 138.6007 confirmed     8      Q1
## 1044 2020-03-21 Australia -34.9285 138.6007 confirmed    17      Q1
## 1045 2020-03-22 Australia -34.9285 138.6007 confirmed    33      Q1
## 1046 2020-03-23 Australia -34.9285 138.6007 confirmed    34      Q1
## 1047 2020-03-24 Australia -34.9285 138.6007 confirmed    36      Q1
## 1048 2020-03-25 Australia -34.9285 138.6007 confirmed     0      Q1
## 1049 2020-03-26 Australia -34.9285 138.6007 confirmed    65      Q1
## 1050 2020-03-27 Australia -34.9285 138.6007 confirmed    22      Q1
## 1051 2020-03-28 Australia -34.9285 138.6007 confirmed    30      Q1
## 1052 2020-03-29 Australia -34.9285 138.6007 confirmed    12      Q1
## 1053 2020-03-30 Australia -34.9285 138.6007 confirmed     6      Q1
## 1054 2020-03-31 Australia -34.9285 138.6007 confirmed    32      Q1
## 1231 2020-01-22 Australia -42.8821 147.3272 confirmed     0      Q1
## 1232 2020-01-23 Australia -42.8821 147.3272 confirmed     0      Q1
## 1233 2020-01-24 Australia -42.8821 147.3272 confirmed     0      Q1
## 1234 2020-01-25 Australia -42.8821 147.3272 confirmed     0      Q1
## 1235 2020-01-26 Australia -42.8821 147.3272 confirmed     0      Q1
## 1236 2020-01-27 Australia -42.8821 147.3272 confirmed     0      Q1
## 1237 2020-01-28 Australia -42.8821 147.3272 confirmed     0      Q1
## 1238 2020-01-29 Australia -42.8821 147.3272 confirmed     0      Q1
## 1239 2020-01-30 Australia -42.8821 147.3272 confirmed     0      Q1
## 1240 2020-01-31 Australia -42.8821 147.3272 confirmed     0      Q1
## 1241 2020-02-01 Australia -42.8821 147.3272 confirmed     0      Q1
## 1242 2020-02-02 Australia -42.8821 147.3272 confirmed     0      Q1
## 1243 2020-02-03 Australia -42.8821 147.3272 confirmed     0      Q1
## 1244 2020-02-04 Australia -42.8821 147.3272 confirmed     0      Q1
## 1245 2020-02-05 Australia -42.8821 147.3272 confirmed     0      Q1
## 1246 2020-02-06 Australia -42.8821 147.3272 confirmed     0      Q1
## 1247 2020-02-07 Australia -42.8821 147.3272 confirmed     0      Q1
## 1248 2020-02-08 Australia -42.8821 147.3272 confirmed     0      Q1
## 1249 2020-02-09 Australia -42.8821 147.3272 confirmed     0      Q1
## 1250 2020-02-10 Australia -42.8821 147.3272 confirmed     0      Q1
## 1251 2020-02-11 Australia -42.8821 147.3272 confirmed     0      Q1
## 1252 2020-02-12 Australia -42.8821 147.3272 confirmed     0      Q1
## 1253 2020-02-13 Australia -42.8821 147.3272 confirmed     0      Q1
## 1254 2020-02-14 Australia -42.8821 147.3272 confirmed     0      Q1
## 1255 2020-02-15 Australia -42.8821 147.3272 confirmed     0      Q1
## 1256 2020-02-16 Australia -42.8821 147.3272 confirmed     0      Q1
## 1257 2020-02-17 Australia -42.8821 147.3272 confirmed     0      Q1
## 1258 2020-02-18 Australia -42.8821 147.3272 confirmed     0      Q1
## 1259 2020-02-19 Australia -42.8821 147.3272 confirmed     0      Q1
## 1260 2020-02-20 Australia -42.8821 147.3272 confirmed     0      Q1
## 1261 2020-02-21 Australia -42.8821 147.3272 confirmed     0      Q1
## 1262 2020-02-22 Australia -42.8821 147.3272 confirmed     0      Q1
## 1263 2020-02-23 Australia -42.8821 147.3272 confirmed     0      Q1
## 1264 2020-02-24 Australia -42.8821 147.3272 confirmed     0      Q1
## 1265 2020-02-25 Australia -42.8821 147.3272 confirmed     0      Q1
## 1266 2020-02-26 Australia -42.8821 147.3272 confirmed     0      Q1
## 1267 2020-02-27 Australia -42.8821 147.3272 confirmed     0      Q1
## 1268 2020-02-28 Australia -42.8821 147.3272 confirmed     0      Q1
## 1269 2020-02-29 Australia -42.8821 147.3272 confirmed     0      Q1
## 1270 2020-03-01 Australia -42.8821 147.3272 confirmed     0      Q1
## 1271 2020-03-02 Australia -42.8821 147.3272 confirmed     1      Q1
## 1272 2020-03-03 Australia -42.8821 147.3272 confirmed     0      Q1
## 1273 2020-03-04 Australia -42.8821 147.3272 confirmed     0      Q1
## 1274 2020-03-05 Australia -42.8821 147.3272 confirmed     0      Q1
## 1275 2020-03-06 Australia -42.8821 147.3272 confirmed     0      Q1
## 1276 2020-03-07 Australia -42.8821 147.3272 confirmed     0      Q1
## 1277 2020-03-08 Australia -42.8821 147.3272 confirmed     1      Q1
## 1278 2020-03-09 Australia -42.8821 147.3272 confirmed     0      Q1
## 1279 2020-03-10 Australia -42.8821 147.3272 confirmed     0      Q1
## 1280 2020-03-11 Australia -42.8821 147.3272 confirmed     1      Q1
## 1281 2020-03-12 Australia -42.8821 147.3272 confirmed     0      Q1
## 1282 2020-03-13 Australia -42.8821 147.3272 confirmed     2      Q1
## 1283 2020-03-14 Australia -42.8821 147.3272 confirmed     0      Q1
## 1284 2020-03-15 Australia -42.8821 147.3272 confirmed     1      Q1
## 1285 2020-03-16 Australia -42.8821 147.3272 confirmed     1      Q1
## 1286 2020-03-17 Australia -42.8821 147.3272 confirmed     0      Q1
## 1287 2020-03-18 Australia -42.8821 147.3272 confirmed     3      Q1
## 1288 2020-03-19 Australia -42.8821 147.3272 confirmed     0      Q1
## 1289 2020-03-20 Australia -42.8821 147.3272 confirmed     0      Q1
## 1290 2020-03-21 Australia -42.8821 147.3272 confirmed     6      Q1
## 1291 2020-03-22 Australia -42.8821 147.3272 confirmed     6      Q1
## 1292 2020-03-23 Australia -42.8821 147.3272 confirmed     6      Q1
## 1293 2020-03-24 Australia -42.8821 147.3272 confirmed     0      Q1
## 1294 2020-03-25 Australia -42.8821 147.3272 confirmed     8      Q1
## 1295 2020-03-26 Australia -42.8821 147.3272 confirmed    11      Q1
## 1296 2020-03-27 Australia -42.8821 147.3272 confirmed     0      Q1
## 1297 2020-03-28 Australia -42.8821 147.3272 confirmed    15      Q1
## 1298 2020-03-29 Australia -42.8821 147.3272 confirmed     4      Q1
## 1299 2020-03-30 Australia -42.8821 147.3272 confirmed     0      Q1
## 1300 2020-03-31 Australia -42.8821 147.3272 confirmed     3      Q1
## 1477 2020-01-22 Australia -37.8136 144.9631 confirmed     0      Q1
## 1478 2020-01-23 Australia -37.8136 144.9631 confirmed     0      Q1
## 1479 2020-01-24 Australia -37.8136 144.9631 confirmed     0      Q1
## 1480 2020-01-25 Australia -37.8136 144.9631 confirmed     0      Q1
## 1481 2020-01-26 Australia -37.8136 144.9631 confirmed     1      Q1
## 1482 2020-01-27 Australia -37.8136 144.9631 confirmed     0      Q1
## 1483 2020-01-28 Australia -37.8136 144.9631 confirmed     0      Q1
## 1484 2020-01-29 Australia -37.8136 144.9631 confirmed     0      Q1
## 1485 2020-01-30 Australia -37.8136 144.9631 confirmed     1      Q1
## 1486 2020-01-31 Australia -37.8136 144.9631 confirmed     1      Q1
## 1487 2020-02-01 Australia -37.8136 144.9631 confirmed     1      Q1
## 1488 2020-02-02 Australia -37.8136 144.9631 confirmed     0      Q1
## 1489 2020-02-03 Australia -37.8136 144.9631 confirmed     0      Q1
## 1490 2020-02-04 Australia -37.8136 144.9631 confirmed     0      Q1
## 1491 2020-02-05 Australia -37.8136 144.9631 confirmed     0      Q1
## 1492 2020-02-06 Australia -37.8136 144.9631 confirmed     0      Q1
## 1493 2020-02-07 Australia -37.8136 144.9631 confirmed     0      Q1
## 1494 2020-02-08 Australia -37.8136 144.9631 confirmed     0      Q1
## 1495 2020-02-09 Australia -37.8136 144.9631 confirmed     0      Q1
## 1496 2020-02-10 Australia -37.8136 144.9631 confirmed     0      Q1
## 1497 2020-02-11 Australia -37.8136 144.9631 confirmed     0      Q1
## 1498 2020-02-12 Australia -37.8136 144.9631 confirmed     0      Q1
## 1499 2020-02-13 Australia -37.8136 144.9631 confirmed     0      Q1
## 1500 2020-02-14 Australia -37.8136 144.9631 confirmed     0      Q1
## 1501 2020-02-15 Australia -37.8136 144.9631 confirmed     0      Q1
## 1502 2020-02-16 Australia -37.8136 144.9631 confirmed     0      Q1
## 1503 2020-02-17 Australia -37.8136 144.9631 confirmed     0      Q1
## 1504 2020-02-18 Australia -37.8136 144.9631 confirmed     0      Q1
## 1505 2020-02-19 Australia -37.8136 144.9631 confirmed     0      Q1
## 1506 2020-02-20 Australia -37.8136 144.9631 confirmed     0      Q1
## 1507 2020-02-21 Australia -37.8136 144.9631 confirmed     0      Q1
## 1508 2020-02-22 Australia -37.8136 144.9631 confirmed     0      Q1
## 1509 2020-02-23 Australia -37.8136 144.9631 confirmed     0      Q1
## 1510 2020-02-24 Australia -37.8136 144.9631 confirmed     0      Q1
## 1511 2020-02-25 Australia -37.8136 144.9631 confirmed     0      Q1
## 1512 2020-02-26 Australia -37.8136 144.9631 confirmed     0      Q1
## 1513 2020-02-27 Australia -37.8136 144.9631 confirmed     0      Q1
## 1514 2020-02-28 Australia -37.8136 144.9631 confirmed     0      Q1
## 1515 2020-02-29 Australia -37.8136 144.9631 confirmed     3      Q1
## 1516 2020-03-01 Australia -37.8136 144.9631 confirmed     0      Q1
## 1517 2020-03-02 Australia -37.8136 144.9631 confirmed     2      Q1
## 1518 2020-03-03 Australia -37.8136 144.9631 confirmed     0      Q1
## 1519 2020-03-04 Australia -37.8136 144.9631 confirmed     1      Q1
## 1520 2020-03-05 Australia -37.8136 144.9631 confirmed     0      Q1
## 1521 2020-03-06 Australia -37.8136 144.9631 confirmed     0      Q1
## 1522 2020-03-07 Australia -37.8136 144.9631 confirmed     1      Q1
## 1523 2020-03-08 Australia -37.8136 144.9631 confirmed     0      Q1
## 1524 2020-03-09 Australia -37.8136 144.9631 confirmed     4      Q1
## 1525 2020-03-10 Australia -37.8136 144.9631 confirmed     3      Q1
## 1526 2020-03-11 Australia -37.8136 144.9631 confirmed     3      Q1
## 1527 2020-03-12 Australia -37.8136 144.9631 confirmed     0      Q1
## 1528 2020-03-13 Australia -37.8136 144.9631 confirmed    15      Q1
## 1529 2020-03-14 Australia -37.8136 144.9631 confirmed    13      Q1
## 1530 2020-03-15 Australia -37.8136 144.9631 confirmed     8      Q1
## 1531 2020-03-16 Australia -37.8136 144.9631 confirmed    14      Q1
## 1532 2020-03-17 Australia -37.8136 144.9631 confirmed    23      Q1
## 1533 2020-03-18 Australia -37.8136 144.9631 confirmed    27      Q1
## 1534 2020-03-19 Australia -37.8136 144.9631 confirmed     0      Q1
## 1535 2020-03-20 Australia -37.8136 144.9631 confirmed     0      Q1
## 1536 2020-03-21 Australia -37.8136 144.9631 confirmed   108      Q1
## 1537 2020-03-22 Australia -37.8136 144.9631 confirmed   126      Q1
## 1538 2020-03-23 Australia -37.8136 144.9631 confirmed     0      Q1
## 1539 2020-03-24 Australia -37.8136 144.9631 confirmed    56      Q1
## 1540 2020-03-25 Australia -37.8136 144.9631 confirmed    55      Q1
## 1541 2020-03-26 Australia -37.8136 144.9631 confirmed    54      Q1
## 1542 2020-03-27 Australia -37.8136 144.9631 confirmed    54      Q1
## 1543 2020-03-28 Australia -37.8136 144.9631 confirmed   111      Q1
## 1544 2020-03-29 Australia -37.8136 144.9631 confirmed    84      Q1
## 1545 2020-03-30 Australia -37.8136 144.9631 confirmed    52      Q1
## 1546 2020-03-31 Australia -37.8136 144.9631 confirmed    96      Q1
## 1723 2020-01-22 Australia -31.9505 115.8605 confirmed     0      Q1
## 1724 2020-01-23 Australia -31.9505 115.8605 confirmed     0      Q1
## 1725 2020-01-24 Australia -31.9505 115.8605 confirmed     0      Q1
## 1726 2020-01-25 Australia -31.9505 115.8605 confirmed     0      Q1
## 1727 2020-01-26 Australia -31.9505 115.8605 confirmed     0      Q1
## 1728 2020-01-27 Australia -31.9505 115.8605 confirmed     0      Q1
## 1729 2020-01-28 Australia -31.9505 115.8605 confirmed     0      Q1
## 1730 2020-01-29 Australia -31.9505 115.8605 confirmed     0      Q1
## 1731 2020-01-30 Australia -31.9505 115.8605 confirmed     0      Q1
## 1732 2020-01-31 Australia -31.9505 115.8605 confirmed     0      Q1
## 1733 2020-02-01 Australia -31.9505 115.8605 confirmed     0      Q1
## 1734 2020-02-02 Australia -31.9505 115.8605 confirmed     0      Q1
## 1735 2020-02-03 Australia -31.9505 115.8605 confirmed     0      Q1
## 1736 2020-02-04 Australia -31.9505 115.8605 confirmed     0      Q1
## 1737 2020-02-05 Australia -31.9505 115.8605 confirmed     0      Q1
## 1738 2020-02-06 Australia -31.9505 115.8605 confirmed     0      Q1
## 1739 2020-02-07 Australia -31.9505 115.8605 confirmed     0      Q1
## 1740 2020-02-08 Australia -31.9505 115.8605 confirmed     0      Q1
## 1741 2020-02-09 Australia -31.9505 115.8605 confirmed     0      Q1
## 1742 2020-02-10 Australia -31.9505 115.8605 confirmed     0      Q1
## 1743 2020-02-11 Australia -31.9505 115.8605 confirmed     0      Q1
## 1744 2020-02-12 Australia -31.9505 115.8605 confirmed     0      Q1
## 1745 2020-02-13 Australia -31.9505 115.8605 confirmed     0      Q1
## 1746 2020-02-14 Australia -31.9505 115.8605 confirmed     0      Q1
## 1747 2020-02-15 Australia -31.9505 115.8605 confirmed     0      Q1
## 1748 2020-02-16 Australia -31.9505 115.8605 confirmed     0      Q1
## 1749 2020-02-17 Australia -31.9505 115.8605 confirmed     0      Q1
## 1750 2020-02-18 Australia -31.9505 115.8605 confirmed     0      Q1
## 1751 2020-02-19 Australia -31.9505 115.8605 confirmed     0      Q1
## 1752 2020-02-20 Australia -31.9505 115.8605 confirmed     0      Q1
## 1753 2020-02-21 Australia -31.9505 115.8605 confirmed     0      Q1
## 1754 2020-02-22 Australia -31.9505 115.8605 confirmed     0      Q1
## 1755 2020-02-23 Australia -31.9505 115.8605 confirmed     0      Q1
## 1756 2020-02-24 Australia -31.9505 115.8605 confirmed     0      Q1
## 1757 2020-02-25 Australia -31.9505 115.8605 confirmed     0      Q1
## 1758 2020-02-26 Australia -31.9505 115.8605 confirmed     0      Q1
## 1759 2020-02-27 Australia -31.9505 115.8605 confirmed     0      Q1
## 1760 2020-02-28 Australia -31.9505 115.8605 confirmed     0      Q1
## 1761 2020-02-29 Australia -31.9505 115.8605 confirmed     2      Q1
## 1762 2020-03-01 Australia -31.9505 115.8605 confirmed     0      Q1
## 1763 2020-03-02 Australia -31.9505 115.8605 confirmed     0      Q1
## 1764 2020-03-03 Australia -31.9505 115.8605 confirmed     0      Q1
## 1765 2020-03-04 Australia -31.9505 115.8605 confirmed     0      Q1
## 1766 2020-03-05 Australia -31.9505 115.8605 confirmed     1      Q1
## 1767 2020-03-06 Australia -31.9505 115.8605 confirmed     0      Q1
## 1768 2020-03-07 Australia -31.9505 115.8605 confirmed     0      Q1
## 1769 2020-03-08 Australia -31.9505 115.8605 confirmed     0      Q1
## 1770 2020-03-09 Australia -31.9505 115.8605 confirmed     1      Q1
## 1771 2020-03-10 Australia -31.9505 115.8605 confirmed     2      Q1
## 1772 2020-03-11 Australia -31.9505 115.8605 confirmed     3      Q1
## 1773 2020-03-12 Australia -31.9505 115.8605 confirmed     0      Q1
## 1774 2020-03-13 Australia -31.9505 115.8605 confirmed     5      Q1
## 1775 2020-03-14 Australia -31.9505 115.8605 confirmed     3      Q1
## 1776 2020-03-15 Australia -31.9505 115.8605 confirmed     0      Q1
## 1777 2020-03-16 Australia -31.9505 115.8605 confirmed    11      Q1
## 1778 2020-03-17 Australia -31.9505 115.8605 confirmed     3      Q1
## 1779 2020-03-18 Australia -31.9505 115.8605 confirmed     4      Q1
## 1780 2020-03-19 Australia -31.9505 115.8605 confirmed    17      Q1
## 1781 2020-03-20 Australia -31.9505 115.8605 confirmed    12      Q1
## 1782 2020-03-21 Australia -31.9505 115.8605 confirmed    26      Q1
## 1783 2020-03-22 Australia -31.9505 115.8605 confirmed    30      Q1
## 1784 2020-03-23 Australia -31.9505 115.8605 confirmed    20      Q1
## 1785 2020-03-24 Australia -31.9505 115.8605 confirmed    35      Q1
## 1786 2020-03-25 Australia -31.9505 115.8605 confirmed     0      Q1
## 1787 2020-03-26 Australia -31.9505 115.8605 confirmed    56      Q1
## 1788 2020-03-27 Australia -31.9505 115.8605 confirmed     0      Q1
## 1789 2020-03-28 Australia -31.9505 115.8605 confirmed    47      Q1
## 1790 2020-03-29 Australia -31.9505 115.8605 confirmed    33      Q1
## 1791 2020-03-30 Australia -31.9505 115.8605 confirmed    44      Q1
## 1792 2020-03-31 Australia -31.9505 115.8605 confirmed     9      Q1
## 1969 2020-01-22 Australia -35.4735 149.0124     death     0      Q1
## 1970 2020-01-23 Australia -35.4735 149.0124     death     0      Q1
## 1971 2020-01-24 Australia -35.4735 149.0124     death     0      Q1
## 1972 2020-01-25 Australia -35.4735 149.0124     death     0      Q1
## 1973 2020-01-26 Australia -35.4735 149.0124     death     0      Q1
## 1974 2020-01-27 Australia -35.4735 149.0124     death     0      Q1
## 1975 2020-01-28 Australia -35.4735 149.0124     death     0      Q1
## 1976 2020-01-29 Australia -35.4735 149.0124     death     0      Q1
## 1977 2020-01-30 Australia -35.4735 149.0124     death     0      Q1
## 1978 2020-01-31 Australia -35.4735 149.0124     death     0      Q1
## 1979 2020-02-01 Australia -35.4735 149.0124     death     0      Q1
## 1980 2020-02-02 Australia -35.4735 149.0124     death     0      Q1
## 1981 2020-02-03 Australia -35.4735 149.0124     death     0      Q1
## 1982 2020-02-04 Australia -35.4735 149.0124     death     0      Q1
## 1983 2020-02-05 Australia -35.4735 149.0124     death     0      Q1
## 1984 2020-02-06 Australia -35.4735 149.0124     death     0      Q1
## 1985 2020-02-07 Australia -35.4735 149.0124     death     0      Q1
## 1986 2020-02-08 Australia -35.4735 149.0124     death     0      Q1
## 1987 2020-02-09 Australia -35.4735 149.0124     death     0      Q1
## 1988 2020-02-10 Australia -35.4735 149.0124     death     0      Q1
## 1989 2020-02-11 Australia -35.4735 149.0124     death     0      Q1
## 1990 2020-02-12 Australia -35.4735 149.0124     death     0      Q1
## 1991 2020-02-13 Australia -35.4735 149.0124     death     0      Q1
## 1992 2020-02-14 Australia -35.4735 149.0124     death     0      Q1
## 1993 2020-02-15 Australia -35.4735 149.0124     death     0      Q1
## 1994 2020-02-16 Australia -35.4735 149.0124     death     0      Q1
## 1995 2020-02-17 Australia -35.4735 149.0124     death     0      Q1
## 1996 2020-02-18 Australia -35.4735 149.0124     death     0      Q1
## 1997 2020-02-19 Australia -35.4735 149.0124     death     0      Q1
## 1998 2020-02-20 Australia -35.4735 149.0124     death     0      Q1
## 1999 2020-02-21 Australia -35.4735 149.0124     death     0      Q1
## 2000 2020-02-22 Australia -35.4735 149.0124     death     0      Q1
## 2001 2020-02-23 Australia -35.4735 149.0124     death     0      Q1
## 2002 2020-02-24 Australia -35.4735 149.0124     death     0      Q1
## 2003 2020-02-25 Australia -35.4735 149.0124     death     0      Q1
## 2004 2020-02-26 Australia -35.4735 149.0124     death     0      Q1
## 2005 2020-02-27 Australia -35.4735 149.0124     death     0      Q1
## 2006 2020-02-28 Australia -35.4735 149.0124     death     0      Q1
## 2007 2020-02-29 Australia -35.4735 149.0124     death     0      Q1
## 2008 2020-03-01 Australia -35.4735 149.0124     death     0      Q1
## 2009 2020-03-02 Australia -35.4735 149.0124     death     0      Q1
## 2010 2020-03-03 Australia -35.4735 149.0124     death     0      Q1
## 2011 2020-03-04 Australia -35.4735 149.0124     death     0      Q1
## 2012 2020-03-05 Australia -35.4735 149.0124     death     0      Q1
## 2013 2020-03-06 Australia -35.4735 149.0124     death     0      Q1
## 2014 2020-03-07 Australia -35.4735 149.0124     death     0      Q1
## 2015 2020-03-08 Australia -35.4735 149.0124     death     0      Q1
## 2016 2020-03-09 Australia -35.4735 149.0124     death     0      Q1
## 2017 2020-03-10 Australia -35.4735 149.0124     death     0      Q1
## 2018 2020-03-11 Australia -35.4735 149.0124     death     0      Q1
## 2019 2020-03-12 Australia -35.4735 149.0124     death     0      Q1
## 2020 2020-03-13 Australia -35.4735 149.0124     death     0      Q1
## 2021 2020-03-14 Australia -35.4735 149.0124     death     0      Q1
## 2022 2020-03-15 Australia -35.4735 149.0124     death     0      Q1
## 2023 2020-03-16 Australia -35.4735 149.0124     death     0      Q1
## 2024 2020-03-17 Australia -35.4735 149.0124     death     0      Q1
## 2025 2020-03-18 Australia -35.4735 149.0124     death     0      Q1
## 2026 2020-03-19 Australia -35.4735 149.0124     death     0      Q1
## 2027 2020-03-20 Australia -35.4735 149.0124     death     0      Q1
## 2028 2020-03-21 Australia -35.4735 149.0124     death     0      Q1
## 2029 2020-03-22 Australia -35.4735 149.0124     death     0      Q1
## 2030 2020-03-23 Australia -35.4735 149.0124     death     0      Q1
## 2031 2020-03-24 Australia -35.4735 149.0124     death     0      Q1
## 2032 2020-03-25 Australia -35.4735 149.0124     death     0      Q1
## 2033 2020-03-26 Australia -35.4735 149.0124     death     0      Q1
## 2034 2020-03-27 Australia -35.4735 149.0124     death     0      Q1
## 2035 2020-03-28 Australia -35.4735 149.0124     death     0      Q1
## 2036 2020-03-29 Australia -35.4735 149.0124     death     0      Q1
## 2037 2020-03-30 Australia -35.4735 149.0124     death     1      Q1
## 2038 2020-03-31 Australia -35.4735 149.0124     death     0      Q1
## 2215 2020-01-22 Australia -33.8688 151.2093     death     0      Q1
## 2216 2020-01-23 Australia -33.8688 151.2093     death     0      Q1
## 2217 2020-01-24 Australia -33.8688 151.2093     death     0      Q1
## 2218 2020-01-25 Australia -33.8688 151.2093     death     0      Q1
## 2219 2020-01-26 Australia -33.8688 151.2093     death     0      Q1
## 2220 2020-01-27 Australia -33.8688 151.2093     death     0      Q1
## 2221 2020-01-28 Australia -33.8688 151.2093     death     0      Q1
## 2222 2020-01-29 Australia -33.8688 151.2093     death     0      Q1
## 2223 2020-01-30 Australia -33.8688 151.2093     death     0      Q1
## 2224 2020-01-31 Australia -33.8688 151.2093     death     0      Q1
## 2225 2020-02-01 Australia -33.8688 151.2093     death     0      Q1
## 2226 2020-02-02 Australia -33.8688 151.2093     death     0      Q1
## 2227 2020-02-03 Australia -33.8688 151.2093     death     0      Q1
## 2228 2020-02-04 Australia -33.8688 151.2093     death     0      Q1
## 2229 2020-02-05 Australia -33.8688 151.2093     death     0      Q1
## 2230 2020-02-06 Australia -33.8688 151.2093     death     0      Q1
## 2231 2020-02-07 Australia -33.8688 151.2093     death     0      Q1
## 2232 2020-02-08 Australia -33.8688 151.2093     death     0      Q1
## 2233 2020-02-09 Australia -33.8688 151.2093     death     0      Q1
## 2234 2020-02-10 Australia -33.8688 151.2093     death     0      Q1
## 2235 2020-02-11 Australia -33.8688 151.2093     death     0      Q1
## 2236 2020-02-12 Australia -33.8688 151.2093     death     0      Q1
## 2237 2020-02-13 Australia -33.8688 151.2093     death     0      Q1
## 2238 2020-02-14 Australia -33.8688 151.2093     death     0      Q1
## 2239 2020-02-15 Australia -33.8688 151.2093     death     0      Q1
## 2240 2020-02-16 Australia -33.8688 151.2093     death     0      Q1
## 2241 2020-02-17 Australia -33.8688 151.2093     death     0      Q1
## 2242 2020-02-18 Australia -33.8688 151.2093     death     0      Q1
## 2243 2020-02-19 Australia -33.8688 151.2093     death     0      Q1
## 2244 2020-02-20 Australia -33.8688 151.2093     death     0      Q1
## 2245 2020-02-21 Australia -33.8688 151.2093     death     0      Q1
## 2246 2020-02-22 Australia -33.8688 151.2093     death     0      Q1
## 2247 2020-02-23 Australia -33.8688 151.2093     death     0      Q1
## 2248 2020-02-24 Australia -33.8688 151.2093     death     0      Q1
## 2249 2020-02-25 Australia -33.8688 151.2093     death     0      Q1
## 2250 2020-02-26 Australia -33.8688 151.2093     death     0      Q1
## 2251 2020-02-27 Australia -33.8688 151.2093     death     0      Q1
## 2252 2020-02-28 Australia -33.8688 151.2093     death     0      Q1
## 2253 2020-02-29 Australia -33.8688 151.2093     death     0      Q1
## 2254 2020-03-01 Australia -33.8688 151.2093     death     0      Q1
## 2255 2020-03-02 Australia -33.8688 151.2093     death     0      Q1
## 2256 2020-03-03 Australia -33.8688 151.2093     death     0      Q1
## 2257 2020-03-04 Australia -33.8688 151.2093     death     1      Q1
## 2258 2020-03-05 Australia -33.8688 151.2093     death     0      Q1
## 2259 2020-03-06 Australia -33.8688 151.2093     death     0      Q1
## 2260 2020-03-07 Australia -33.8688 151.2093     death     0      Q1
## 2261 2020-03-08 Australia -33.8688 151.2093     death     1      Q1
## 2262 2020-03-09 Australia -33.8688 151.2093     death     0      Q1
## 2263 2020-03-10 Australia -33.8688 151.2093     death     0      Q1
## 2264 2020-03-11 Australia -33.8688 151.2093     death     0      Q1
## 2265 2020-03-12 Australia -33.8688 151.2093     death     0      Q1
## 2266 2020-03-13 Australia -33.8688 151.2093     death     0      Q1
## 2267 2020-03-14 Australia -33.8688 151.2093     death     0      Q1
## 2268 2020-03-15 Australia -33.8688 151.2093     death     0      Q1
## 2269 2020-03-16 Australia -33.8688 151.2093     death     0      Q1
## 2270 2020-03-17 Australia -33.8688 151.2093     death     2      Q1
## 2271 2020-03-18 Australia -33.8688 151.2093     death     1      Q1
## 2272 2020-03-19 Australia -33.8688 151.2093     death     0      Q1
## 2273 2020-03-20 Australia -33.8688 151.2093     death     1      Q1
## 2274 2020-03-21 Australia -33.8688 151.2093     death     0      Q1
## 2275 2020-03-22 Australia -33.8688 151.2093     death     0      Q1
## 2276 2020-03-23 Australia -33.8688 151.2093     death     0      Q1
## 2277 2020-03-24 Australia -33.8688 151.2093     death     1      Q1
## 2278 2020-03-25 Australia -33.8688 151.2093     death     0      Q1
## 2279 2020-03-26 Australia -33.8688 151.2093     death     0      Q1
## 2280 2020-03-27 Australia -33.8688 151.2093     death     0      Q1
## 2281 2020-03-28 Australia -33.8688 151.2093     death     1      Q1
## 2282 2020-03-29 Australia -33.8688 151.2093     death     0      Q1
## 2283 2020-03-30 Australia -33.8688 151.2093     death     0      Q1
## 2284 2020-03-31 Australia -33.8688 151.2093     death     0      Q1
## 2461 2020-01-22 Australia -12.4634 130.8456     death     0      Q1
## 2462 2020-01-23 Australia -12.4634 130.8456     death     0      Q1
## 2463 2020-01-24 Australia -12.4634 130.8456     death     0      Q1
## 2464 2020-01-25 Australia -12.4634 130.8456     death     0      Q1
## 2465 2020-01-26 Australia -12.4634 130.8456     death     0      Q1
## 2466 2020-01-27 Australia -12.4634 130.8456     death     0      Q1
## 2467 2020-01-28 Australia -12.4634 130.8456     death     0      Q1
## 2468 2020-01-29 Australia -12.4634 130.8456     death     0      Q1
## 2469 2020-01-30 Australia -12.4634 130.8456     death     0      Q1
## 2470 2020-01-31 Australia -12.4634 130.8456     death     0      Q1
## 2471 2020-02-01 Australia -12.4634 130.8456     death     0      Q1
## 2472 2020-02-02 Australia -12.4634 130.8456     death     0      Q1
## 2473 2020-02-03 Australia -12.4634 130.8456     death     0      Q1
## 2474 2020-02-04 Australia -12.4634 130.8456     death     0      Q1
## 2475 2020-02-05 Australia -12.4634 130.8456     death     0      Q1
## 2476 2020-02-06 Australia -12.4634 130.8456     death     0      Q1
## 2477 2020-02-07 Australia -12.4634 130.8456     death     0      Q1
## 2478 2020-02-08 Australia -12.4634 130.8456     death     0      Q1
## 2479 2020-02-09 Australia -12.4634 130.8456     death     0      Q1
## 2480 2020-02-10 Australia -12.4634 130.8456     death     0      Q1
## 2481 2020-02-11 Australia -12.4634 130.8456     death     0      Q1
## 2482 2020-02-12 Australia -12.4634 130.8456     death     0      Q1
## 2483 2020-02-13 Australia -12.4634 130.8456     death     0      Q1
## 2484 2020-02-14 Australia -12.4634 130.8456     death     0      Q1
## 2485 2020-02-15 Australia -12.4634 130.8456     death     0      Q1
## 2486 2020-02-16 Australia -12.4634 130.8456     death     0      Q1
## 2487 2020-02-17 Australia -12.4634 130.8456     death     0      Q1
## 2488 2020-02-18 Australia -12.4634 130.8456     death     0      Q1
## 2489 2020-02-19 Australia -12.4634 130.8456     death     0      Q1
## 2490 2020-02-20 Australia -12.4634 130.8456     death     0      Q1
## 2491 2020-02-21 Australia -12.4634 130.8456     death     0      Q1
## 2492 2020-02-22 Australia -12.4634 130.8456     death     0      Q1
## 2493 2020-02-23 Australia -12.4634 130.8456     death     0      Q1
## 2494 2020-02-24 Australia -12.4634 130.8456     death     0      Q1
## 2495 2020-02-25 Australia -12.4634 130.8456     death     0      Q1
## 2496 2020-02-26 Australia -12.4634 130.8456     death     0      Q1
## 2497 2020-02-27 Australia -12.4634 130.8456     death     0      Q1
## 2498 2020-02-28 Australia -12.4634 130.8456     death     0      Q1
## 2499 2020-02-29 Australia -12.4634 130.8456     death     0      Q1
## 2500 2020-03-01 Australia -12.4634 130.8456     death     0      Q1
## 2501 2020-03-02 Australia -12.4634 130.8456     death     0      Q1
## 2502 2020-03-03 Australia -12.4634 130.8456     death     0      Q1
## 2503 2020-03-04 Australia -12.4634 130.8456     death     0      Q1
## 2504 2020-03-05 Australia -12.4634 130.8456     death     0      Q1
## 2505 2020-03-06 Australia -12.4634 130.8456     death     0      Q1
## 2506 2020-03-07 Australia -12.4634 130.8456     death     0      Q1
## 2507 2020-03-08 Australia -12.4634 130.8456     death     0      Q1
## 2508 2020-03-09 Australia -12.4634 130.8456     death     0      Q1
## 2509 2020-03-10 Australia -12.4634 130.8456     death     0      Q1
## 2510 2020-03-11 Australia -12.4634 130.8456     death     0      Q1
## 2511 2020-03-12 Australia -12.4634 130.8456     death     0      Q1
## 2512 2020-03-13 Australia -12.4634 130.8456     death     0      Q1
## 2513 2020-03-14 Australia -12.4634 130.8456     death     0      Q1
## 2514 2020-03-15 Australia -12.4634 130.8456     death     0      Q1
## 2515 2020-03-16 Australia -12.4634 130.8456     death     0      Q1
## 2516 2020-03-17 Australia -12.4634 130.8456     death     0      Q1
## 2517 2020-03-18 Australia -12.4634 130.8456     death     0      Q1
## 2518 2020-03-19 Australia -12.4634 130.8456     death     0      Q1
## 2519 2020-03-20 Australia -12.4634 130.8456     death     0      Q1
## 2520 2020-03-21 Australia -12.4634 130.8456     death     0      Q1
## 2521 2020-03-22 Australia -12.4634 130.8456     death     0      Q1
## 2522 2020-03-23 Australia -12.4634 130.8456     death     0      Q1
## 2523 2020-03-24 Australia -12.4634 130.8456     death     0      Q1
## 2524 2020-03-25 Australia -12.4634 130.8456     death     0      Q1
## 2525 2020-03-26 Australia -12.4634 130.8456     death     0      Q1
## 2526 2020-03-27 Australia -12.4634 130.8456     death     0      Q1
## 2527 2020-03-28 Australia -12.4634 130.8456     death     0      Q1
## 2528 2020-03-29 Australia -12.4634 130.8456     death     0      Q1
## 2529 2020-03-30 Australia -12.4634 130.8456     death     0      Q1
## 2530 2020-03-31 Australia -12.4634 130.8456     death     0      Q1
## 2707 2020-01-22 Australia -27.4698 153.0251     death     0      Q1
## 2708 2020-01-23 Australia -27.4698 153.0251     death     0      Q1
## 2709 2020-01-24 Australia -27.4698 153.0251     death     0      Q1
## 2710 2020-01-25 Australia -27.4698 153.0251     death     0      Q1
## 2711 2020-01-26 Australia -27.4698 153.0251     death     0      Q1
## 2712 2020-01-27 Australia -27.4698 153.0251     death     0      Q1
## 2713 2020-01-28 Australia -27.4698 153.0251     death     0      Q1
## 2714 2020-01-29 Australia -27.4698 153.0251     death     0      Q1
## 2715 2020-01-30 Australia -27.4698 153.0251     death     0      Q1
## 2716 2020-01-31 Australia -27.4698 153.0251     death     0      Q1
## 2717 2020-02-01 Australia -27.4698 153.0251     death     0      Q1
## 2718 2020-02-02 Australia -27.4698 153.0251     death     0      Q1
## 2719 2020-02-03 Australia -27.4698 153.0251     death     0      Q1
## 2720 2020-02-04 Australia -27.4698 153.0251     death     0      Q1
## 2721 2020-02-05 Australia -27.4698 153.0251     death     0      Q1
## 2722 2020-02-06 Australia -27.4698 153.0251     death     0      Q1
## 2723 2020-02-07 Australia -27.4698 153.0251     death     0      Q1
## 2724 2020-02-08 Australia -27.4698 153.0251     death     0      Q1
## 2725 2020-02-09 Australia -27.4698 153.0251     death     0      Q1
## 2726 2020-02-10 Australia -27.4698 153.0251     death     0      Q1
## 2727 2020-02-11 Australia -27.4698 153.0251     death     0      Q1
## 2728 2020-02-12 Australia -27.4698 153.0251     death     0      Q1
## 2729 2020-02-13 Australia -27.4698 153.0251     death     0      Q1
## 2730 2020-02-14 Australia -27.4698 153.0251     death     0      Q1
## 2731 2020-02-15 Australia -27.4698 153.0251     death     0      Q1
## 2732 2020-02-16 Australia -27.4698 153.0251     death     0      Q1
## 2733 2020-02-17 Australia -27.4698 153.0251     death     0      Q1
## 2734 2020-02-18 Australia -27.4698 153.0251     death     0      Q1
## 2735 2020-02-19 Australia -27.4698 153.0251     death     0      Q1
## 2736 2020-02-20 Australia -27.4698 153.0251     death     0      Q1
## 2737 2020-02-21 Australia -27.4698 153.0251     death     0      Q1
## 2738 2020-02-22 Australia -27.4698 153.0251     death     0      Q1
## 2739 2020-02-23 Australia -27.4698 153.0251     death     0      Q1
## 2740 2020-02-24 Australia -27.4698 153.0251     death     0      Q1
## 2741 2020-02-25 Australia -27.4698 153.0251     death     0      Q1
## 2742 2020-02-26 Australia -27.4698 153.0251     death     0      Q1
## 2743 2020-02-27 Australia -27.4698 153.0251     death     0      Q1
## 2744 2020-02-28 Australia -27.4698 153.0251     death     0      Q1
## 2745 2020-02-29 Australia -27.4698 153.0251     death     0      Q1
## 2746 2020-03-01 Australia -27.4698 153.0251     death     0      Q1
## 2747 2020-03-02 Australia -27.4698 153.0251     death     0      Q1
## 2748 2020-03-03 Australia -27.4698 153.0251     death     0      Q1
## 2749 2020-03-04 Australia -27.4698 153.0251     death     0      Q1
## 2750 2020-03-05 Australia -27.4698 153.0251     death     0      Q1
## 2751 2020-03-06 Australia -27.4698 153.0251     death     0      Q1
## 2752 2020-03-07 Australia -27.4698 153.0251     death     0      Q1
## 2753 2020-03-08 Australia -27.4698 153.0251     death     0      Q1
## 2754 2020-03-09 Australia -27.4698 153.0251     death     0      Q1
## 2755 2020-03-10 Australia -27.4698 153.0251     death     0      Q1
## 2756 2020-03-11 Australia -27.4698 153.0251     death     0      Q1
## 2757 2020-03-12 Australia -27.4698 153.0251     death     0      Q1
## 2758 2020-03-13 Australia -27.4698 153.0251     death     0      Q1
## 2759 2020-03-14 Australia -27.4698 153.0251     death     0      Q1
## 2760 2020-03-15 Australia -27.4698 153.0251     death     0      Q1
## 2761 2020-03-16 Australia -27.4698 153.0251     death     0      Q1
## 2762 2020-03-17 Australia -27.4698 153.0251     death     0      Q1
## 2763 2020-03-18 Australia -27.4698 153.0251     death     0      Q1
## 2764 2020-03-19 Australia -27.4698 153.0251     death     0      Q1
## 2765 2020-03-20 Australia -27.4698 153.0251     death     0      Q1
## 2766 2020-03-21 Australia -27.4698 153.0251     death     0      Q1
## 2767 2020-03-22 Australia -27.4698 153.0251     death     0      Q1
## 2768 2020-03-23 Australia -27.4698 153.0251     death     0      Q1
## 2769 2020-03-24 Australia -27.4698 153.0251     death     0      Q1
## 2770 2020-03-25 Australia -27.4698 153.0251     death     0      Q1
## 2771 2020-03-26 Australia -27.4698 153.0251     death     1      Q1
## 2772 2020-03-27 Australia -27.4698 153.0251     death     0      Q1
## 2773 2020-03-28 Australia -27.4698 153.0251     death     0      Q1
## 2774 2020-03-29 Australia -27.4698 153.0251     death     1      Q1
## 2775 2020-03-30 Australia -27.4698 153.0251     death     0      Q1
## 2776 2020-03-31 Australia -27.4698 153.0251     death     0      Q1
## 2953 2020-01-22 Australia -34.9285 138.6007     death     0      Q1
## 2954 2020-01-23 Australia -34.9285 138.6007     death     0      Q1
## 2955 2020-01-24 Australia -34.9285 138.6007     death     0      Q1
## 2956 2020-01-25 Australia -34.9285 138.6007     death     0      Q1
## 2957 2020-01-26 Australia -34.9285 138.6007     death     0      Q1
## 2958 2020-01-27 Australia -34.9285 138.6007     death     0      Q1
## 2959 2020-01-28 Australia -34.9285 138.6007     death     0      Q1
## 2960 2020-01-29 Australia -34.9285 138.6007     death     0      Q1
## 2961 2020-01-30 Australia -34.9285 138.6007     death     0      Q1
## 2962 2020-01-31 Australia -34.9285 138.6007     death     0      Q1
## 2963 2020-02-01 Australia -34.9285 138.6007     death     0      Q1
## 2964 2020-02-02 Australia -34.9285 138.6007     death     0      Q1
## 2965 2020-02-03 Australia -34.9285 138.6007     death     0      Q1
## 2966 2020-02-04 Australia -34.9285 138.6007     death     0      Q1
## 2967 2020-02-05 Australia -34.9285 138.6007     death     0      Q1
## 2968 2020-02-06 Australia -34.9285 138.6007     death     0      Q1
## 2969 2020-02-07 Australia -34.9285 138.6007     death     0      Q1
## 2970 2020-02-08 Australia -34.9285 138.6007     death     0      Q1
## 2971 2020-02-09 Australia -34.9285 138.6007     death     0      Q1
## 2972 2020-02-10 Australia -34.9285 138.6007     death     0      Q1
## 2973 2020-02-11 Australia -34.9285 138.6007     death     0      Q1
## 2974 2020-02-12 Australia -34.9285 138.6007     death     0      Q1
## 2975 2020-02-13 Australia -34.9285 138.6007     death     0      Q1
## 2976 2020-02-14 Australia -34.9285 138.6007     death     0      Q1
## 2977 2020-02-15 Australia -34.9285 138.6007     death     0      Q1
## 2978 2020-02-16 Australia -34.9285 138.6007     death     0      Q1
## 2979 2020-02-17 Australia -34.9285 138.6007     death     0      Q1
## 2980 2020-02-18 Australia -34.9285 138.6007     death     0      Q1
## 2981 2020-02-19 Australia -34.9285 138.6007     death     0      Q1
## 2982 2020-02-20 Australia -34.9285 138.6007     death     0      Q1
## 2983 2020-02-21 Australia -34.9285 138.6007     death     0      Q1
## 2984 2020-02-22 Australia -34.9285 138.6007     death     0      Q1
## 2985 2020-02-23 Australia -34.9285 138.6007     death     0      Q1
## 2986 2020-02-24 Australia -34.9285 138.6007     death     0      Q1
## 2987 2020-02-25 Australia -34.9285 138.6007     death     0      Q1
## 2988 2020-02-26 Australia -34.9285 138.6007     death     0      Q1
## 2989 2020-02-27 Australia -34.9285 138.6007     death     0      Q1
## 2990 2020-02-28 Australia -34.9285 138.6007     death     0      Q1
## 2991 2020-02-29 Australia -34.9285 138.6007     death     0      Q1
## 2992 2020-03-01 Australia -34.9285 138.6007     death     0      Q1
## 2993 2020-03-02 Australia -34.9285 138.6007     death     0      Q1
## 2994 2020-03-03 Australia -34.9285 138.6007     death     0      Q1
## 2995 2020-03-04 Australia -34.9285 138.6007     death     0      Q1
## 2996 2020-03-05 Australia -34.9285 138.6007     death     0      Q1
## 2997 2020-03-06 Australia -34.9285 138.6007     death     0      Q1
## 2998 2020-03-07 Australia -34.9285 138.6007     death     0      Q1
## 2999 2020-03-08 Australia -34.9285 138.6007     death     0      Q1
## 3000 2020-03-09 Australia -34.9285 138.6007     death     0      Q1
## 3001 2020-03-10 Australia -34.9285 138.6007     death     0      Q1
## 3002 2020-03-11 Australia -34.9285 138.6007     death     0      Q1
## 3003 2020-03-12 Australia -34.9285 138.6007     death     0      Q1
## 3004 2020-03-13 Australia -34.9285 138.6007     death     0      Q1
## 3005 2020-03-14 Australia -34.9285 138.6007     death     0      Q1
## 3006 2020-03-15 Australia -34.9285 138.6007     death     0      Q1
## 3007 2020-03-16 Australia -34.9285 138.6007     death     0      Q1
## 3008 2020-03-17 Australia -34.9285 138.6007     death     0      Q1
## 3009 2020-03-18 Australia -34.9285 138.6007     death     0      Q1
## 3010 2020-03-19 Australia -34.9285 138.6007     death     0      Q1
## 3011 2020-03-20 Australia -34.9285 138.6007     death     0      Q1
## 3012 2020-03-21 Australia -34.9285 138.6007     death     0      Q1
## 3013 2020-03-22 Australia -34.9285 138.6007     death     0      Q1
## 3014 2020-03-23 Australia -34.9285 138.6007     death     0      Q1
## 3015 2020-03-24 Australia -34.9285 138.6007     death     0      Q1
## 3016 2020-03-25 Australia -34.9285 138.6007     death     0      Q1
## 3017 2020-03-26 Australia -34.9285 138.6007     death     0      Q1
## 3018 2020-03-27 Australia -34.9285 138.6007     death     0      Q1
## 3019 2020-03-28 Australia -34.9285 138.6007     death     0      Q1
## 3020 2020-03-29 Australia -34.9285 138.6007     death     0      Q1
## 3021 2020-03-30 Australia -34.9285 138.6007     death     0      Q1
## 3022 2020-03-31 Australia -34.9285 138.6007     death     0      Q1
## 3199 2020-01-22 Australia -42.8821 147.3272     death     0      Q1
## 3200 2020-01-23 Australia -42.8821 147.3272     death     0      Q1
## 3201 2020-01-24 Australia -42.8821 147.3272     death     0      Q1
## 3202 2020-01-25 Australia -42.8821 147.3272     death     0      Q1
## 3203 2020-01-26 Australia -42.8821 147.3272     death     0      Q1
## 3204 2020-01-27 Australia -42.8821 147.3272     death     0      Q1
## 3205 2020-01-28 Australia -42.8821 147.3272     death     0      Q1
## 3206 2020-01-29 Australia -42.8821 147.3272     death     0      Q1
## 3207 2020-01-30 Australia -42.8821 147.3272     death     0      Q1
## 3208 2020-01-31 Australia -42.8821 147.3272     death     0      Q1
## 3209 2020-02-01 Australia -42.8821 147.3272     death     0      Q1
## 3210 2020-02-02 Australia -42.8821 147.3272     death     0      Q1
## 3211 2020-02-03 Australia -42.8821 147.3272     death     0      Q1
## 3212 2020-02-04 Australia -42.8821 147.3272     death     0      Q1
## 3213 2020-02-05 Australia -42.8821 147.3272     death     0      Q1
## 3214 2020-02-06 Australia -42.8821 147.3272     death     0      Q1
## 3215 2020-02-07 Australia -42.8821 147.3272     death     0      Q1
## 3216 2020-02-08 Australia -42.8821 147.3272     death     0      Q1
## 3217 2020-02-09 Australia -42.8821 147.3272     death     0      Q1
## 3218 2020-02-10 Australia -42.8821 147.3272     death     0      Q1
## 3219 2020-02-11 Australia -42.8821 147.3272     death     0      Q1
## 3220 2020-02-12 Australia -42.8821 147.3272     death     0      Q1
## 3221 2020-02-13 Australia -42.8821 147.3272     death     0      Q1
## 3222 2020-02-14 Australia -42.8821 147.3272     death     0      Q1
## 3223 2020-02-15 Australia -42.8821 147.3272     death     0      Q1
## 3224 2020-02-16 Australia -42.8821 147.3272     death     0      Q1
## 3225 2020-02-17 Australia -42.8821 147.3272     death     0      Q1
## 3226 2020-02-18 Australia -42.8821 147.3272     death     0      Q1
## 3227 2020-02-19 Australia -42.8821 147.3272     death     0      Q1
## 3228 2020-02-20 Australia -42.8821 147.3272     death     0      Q1
## 3229 2020-02-21 Australia -42.8821 147.3272     death     0      Q1
## 3230 2020-02-22 Australia -42.8821 147.3272     death     0      Q1
## 3231 2020-02-23 Australia -42.8821 147.3272     death     0      Q1
## 3232 2020-02-24 Australia -42.8821 147.3272     death     0      Q1
## 3233 2020-02-25 Australia -42.8821 147.3272     death     0      Q1
## 3234 2020-02-26 Australia -42.8821 147.3272     death     0      Q1
## 3235 2020-02-27 Australia -42.8821 147.3272     death     0      Q1
## 3236 2020-02-28 Australia -42.8821 147.3272     death     0      Q1
## 3237 2020-02-29 Australia -42.8821 147.3272     death     0      Q1
## 3238 2020-03-01 Australia -42.8821 147.3272     death     0      Q1
## 3239 2020-03-02 Australia -42.8821 147.3272     death     0      Q1
## 3240 2020-03-03 Australia -42.8821 147.3272     death     0      Q1
## 3241 2020-03-04 Australia -42.8821 147.3272     death     0      Q1
## 3242 2020-03-05 Australia -42.8821 147.3272     death     0      Q1
## 3243 2020-03-06 Australia -42.8821 147.3272     death     0      Q1
## 3244 2020-03-07 Australia -42.8821 147.3272     death     0      Q1
## 3245 2020-03-08 Australia -42.8821 147.3272     death     0      Q1
## 3246 2020-03-09 Australia -42.8821 147.3272     death     0      Q1
## 3247 2020-03-10 Australia -42.8821 147.3272     death     0      Q1
## 3248 2020-03-11 Australia -42.8821 147.3272     death     0      Q1
## 3249 2020-03-12 Australia -42.8821 147.3272     death     0      Q1
## 3250 2020-03-13 Australia -42.8821 147.3272     death     0      Q1
## 3251 2020-03-14 Australia -42.8821 147.3272     death     0      Q1
## 3252 2020-03-15 Australia -42.8821 147.3272     death     0      Q1
## 3253 2020-03-16 Australia -42.8821 147.3272     death     0      Q1
## 3254 2020-03-17 Australia -42.8821 147.3272     death     0      Q1
## 3255 2020-03-18 Australia -42.8821 147.3272     death     0      Q1
## 3256 2020-03-19 Australia -42.8821 147.3272     death     0      Q1
## 3257 2020-03-20 Australia -42.8821 147.3272     death     0      Q1
## 3258 2020-03-21 Australia -42.8821 147.3272     death     0      Q1
## 3259 2020-03-22 Australia -42.8821 147.3272     death     0      Q1
## 3260 2020-03-23 Australia -42.8821 147.3272     death     0      Q1
## 3261 2020-03-24 Australia -42.8821 147.3272     death     0      Q1
## 3262 2020-03-25 Australia -42.8821 147.3272     death     0      Q1
## 3263 2020-03-26 Australia -42.8821 147.3272     death     0      Q1
## 3264 2020-03-27 Australia -42.8821 147.3272     death     0      Q1
## 3265 2020-03-28 Australia -42.8821 147.3272     death     0      Q1
## 3266 2020-03-29 Australia -42.8821 147.3272     death     0      Q1
## 3267 2020-03-30 Australia -42.8821 147.3272     death     0      Q1
## 3268 2020-03-31 Australia -42.8821 147.3272     death     1      Q1
## 3445 2020-01-22 Australia -37.8136 144.9631     death     0      Q1
## 3446 2020-01-23 Australia -37.8136 144.9631     death     0      Q1
## 3447 2020-01-24 Australia -37.8136 144.9631     death     0      Q1
## 3448 2020-01-25 Australia -37.8136 144.9631     death     0      Q1
## 3449 2020-01-26 Australia -37.8136 144.9631     death     0      Q1
## 3450 2020-01-27 Australia -37.8136 144.9631     death     0      Q1
## 3451 2020-01-28 Australia -37.8136 144.9631     death     0      Q1
## 3452 2020-01-29 Australia -37.8136 144.9631     death     0      Q1
## 3453 2020-01-30 Australia -37.8136 144.9631     death     0      Q1
## 3454 2020-01-31 Australia -37.8136 144.9631     death     0      Q1
## 3455 2020-02-01 Australia -37.8136 144.9631     death     0      Q1
## 3456 2020-02-02 Australia -37.8136 144.9631     death     0      Q1
## 3457 2020-02-03 Australia -37.8136 144.9631     death     0      Q1
## 3458 2020-02-04 Australia -37.8136 144.9631     death     0      Q1
## 3459 2020-02-05 Australia -37.8136 144.9631     death     0      Q1
## 3460 2020-02-06 Australia -37.8136 144.9631     death     0      Q1
## 3461 2020-02-07 Australia -37.8136 144.9631     death     0      Q1
## 3462 2020-02-08 Australia -37.8136 144.9631     death     0      Q1
## 3463 2020-02-09 Australia -37.8136 144.9631     death     0      Q1
## 3464 2020-02-10 Australia -37.8136 144.9631     death     0      Q1
## 3465 2020-02-11 Australia -37.8136 144.9631     death     0      Q1
## 3466 2020-02-12 Australia -37.8136 144.9631     death     0      Q1
## 3467 2020-02-13 Australia -37.8136 144.9631     death     0      Q1
## 3468 2020-02-14 Australia -37.8136 144.9631     death     0      Q1
## 3469 2020-02-15 Australia -37.8136 144.9631     death     0      Q1
## 3470 2020-02-16 Australia -37.8136 144.9631     death     0      Q1
## 3471 2020-02-17 Australia -37.8136 144.9631     death     0      Q1
## 3472 2020-02-18 Australia -37.8136 144.9631     death     0      Q1
## 3473 2020-02-19 Australia -37.8136 144.9631     death     0      Q1
## 3474 2020-02-20 Australia -37.8136 144.9631     death     0      Q1
## 3475 2020-02-21 Australia -37.8136 144.9631     death     0      Q1
## 3476 2020-02-22 Australia -37.8136 144.9631     death     0      Q1
## 3477 2020-02-23 Australia -37.8136 144.9631     death     0      Q1
## 3478 2020-02-24 Australia -37.8136 144.9631     death     0      Q1
## 3479 2020-02-25 Australia -37.8136 144.9631     death     0      Q1
## 3480 2020-02-26 Australia -37.8136 144.9631     death     0      Q1
## 3481 2020-02-27 Australia -37.8136 144.9631     death     0      Q1
## 3482 2020-02-28 Australia -37.8136 144.9631     death     0      Q1
## 3483 2020-02-29 Australia -37.8136 144.9631     death     0      Q1
## 3484 2020-03-01 Australia -37.8136 144.9631     death     0      Q1
## 3485 2020-03-02 Australia -37.8136 144.9631     death     0      Q1
## 3486 2020-03-03 Australia -37.8136 144.9631     death     0      Q1
## 3487 2020-03-04 Australia -37.8136 144.9631     death     0      Q1
## 3488 2020-03-05 Australia -37.8136 144.9631     death     0      Q1
## 3489 2020-03-06 Australia -37.8136 144.9631     death     0      Q1
## 3490 2020-03-07 Australia -37.8136 144.9631     death     0      Q1
## 3491 2020-03-08 Australia -37.8136 144.9631     death     0      Q1
## 3492 2020-03-09 Australia -37.8136 144.9631     death     0      Q1
## 3493 2020-03-10 Australia -37.8136 144.9631     death     0      Q1
## 3494 2020-03-11 Australia -37.8136 144.9631     death     0      Q1
## 3495 2020-03-12 Australia -37.8136 144.9631     death     0      Q1
## 3496 2020-03-13 Australia -37.8136 144.9631     death     0      Q1
## 3497 2020-03-14 Australia -37.8136 144.9631     death     0      Q1
## 3498 2020-03-15 Australia -37.8136 144.9631     death     0      Q1
## 3499 2020-03-16 Australia -37.8136 144.9631     death     0      Q1
## 3500 2020-03-17 Australia -37.8136 144.9631     death     0      Q1
## 3501 2020-03-18 Australia -37.8136 144.9631     death     0      Q1
## 3502 2020-03-19 Australia -37.8136 144.9631     death     0      Q1
## 3503 2020-03-20 Australia -37.8136 144.9631     death     0      Q1
## 3504 2020-03-21 Australia -37.8136 144.9631     death     0      Q1
## 3505 2020-03-22 Australia -37.8136 144.9631     death     0      Q1
## 3506 2020-03-23 Australia -37.8136 144.9631     death     0      Q1
## 3507 2020-03-24 Australia -37.8136 144.9631     death     0      Q1
## 3508 2020-03-25 Australia -37.8136 144.9631     death     0      Q1
## 3509 2020-03-26 Australia -37.8136 144.9631     death     3      Q1
## 3510 2020-03-27 Australia -37.8136 144.9631     death     0      Q1
## 3511 2020-03-28 Australia -37.8136 144.9631     death     0      Q1
## 3512 2020-03-29 Australia -37.8136 144.9631     death     1      Q1
## 3513 2020-03-30 Australia -37.8136 144.9631     death     0      Q1
## 3514 2020-03-31 Australia -37.8136 144.9631     death     0      Q1
## 3691 2020-01-22 Australia -31.9505 115.8605     death     0      Q1
## 3692 2020-01-23 Australia -31.9505 115.8605     death     0      Q1
## 3693 2020-01-24 Australia -31.9505 115.8605     death     0      Q1
## 3694 2020-01-25 Australia -31.9505 115.8605     death     0      Q1
## 3695 2020-01-26 Australia -31.9505 115.8605     death     0      Q1
## 3696 2020-01-27 Australia -31.9505 115.8605     death     0      Q1
## 3697 2020-01-28 Australia -31.9505 115.8605     death     0      Q1
## 3698 2020-01-29 Australia -31.9505 115.8605     death     0      Q1
## 3699 2020-01-30 Australia -31.9505 115.8605     death     0      Q1
## 3700 2020-01-31 Australia -31.9505 115.8605     death     0      Q1
## 3701 2020-02-01 Australia -31.9505 115.8605     death     0      Q1
## 3702 2020-02-02 Australia -31.9505 115.8605     death     0      Q1
## 3703 2020-02-03 Australia -31.9505 115.8605     death     0      Q1
## 3704 2020-02-04 Australia -31.9505 115.8605     death     0      Q1
## 3705 2020-02-05 Australia -31.9505 115.8605     death     0      Q1
## 3706 2020-02-06 Australia -31.9505 115.8605     death     0      Q1
## 3707 2020-02-07 Australia -31.9505 115.8605     death     0      Q1
## 3708 2020-02-08 Australia -31.9505 115.8605     death     0      Q1
## 3709 2020-02-09 Australia -31.9505 115.8605     death     0      Q1
## 3710 2020-02-10 Australia -31.9505 115.8605     death     0      Q1
## 3711 2020-02-11 Australia -31.9505 115.8605     death     0      Q1
## 3712 2020-02-12 Australia -31.9505 115.8605     death     0      Q1
## 3713 2020-02-13 Australia -31.9505 115.8605     death     0      Q1
## 3714 2020-02-14 Australia -31.9505 115.8605     death     0      Q1
## 3715 2020-02-15 Australia -31.9505 115.8605     death     0      Q1
## 3716 2020-02-16 Australia -31.9505 115.8605     death     0      Q1
## 3717 2020-02-17 Australia -31.9505 115.8605     death     0      Q1
## 3718 2020-02-18 Australia -31.9505 115.8605     death     0      Q1
## 3719 2020-02-19 Australia -31.9505 115.8605     death     0      Q1
## 3720 2020-02-20 Australia -31.9505 115.8605     death     0      Q1
## 3721 2020-02-21 Australia -31.9505 115.8605     death     0      Q1
## 3722 2020-02-22 Australia -31.9505 115.8605     death     0      Q1
## 3723 2020-02-23 Australia -31.9505 115.8605     death     0      Q1
## 3724 2020-02-24 Australia -31.9505 115.8605     death     0      Q1
## 3725 2020-02-25 Australia -31.9505 115.8605     death     0      Q1
## 3726 2020-02-26 Australia -31.9505 115.8605     death     0      Q1
## 3727 2020-02-27 Australia -31.9505 115.8605     death     0      Q1
## 3728 2020-02-28 Australia -31.9505 115.8605     death     0      Q1
## 3729 2020-02-29 Australia -31.9505 115.8605     death     0      Q1
## 3730 2020-03-01 Australia -31.9505 115.8605     death     1      Q1
## 3731 2020-03-02 Australia -31.9505 115.8605     death     0      Q1
## 3732 2020-03-03 Australia -31.9505 115.8605     death     0      Q1
## 3733 2020-03-04 Australia -31.9505 115.8605     death     0      Q1
## 3734 2020-03-05 Australia -31.9505 115.8605     death     0      Q1
## 3735 2020-03-06 Australia -31.9505 115.8605     death     0      Q1
## 3736 2020-03-07 Australia -31.9505 115.8605     death     0      Q1
## 3737 2020-03-08 Australia -31.9505 115.8605     death     0      Q1
## 3738 2020-03-09 Australia -31.9505 115.8605     death     0      Q1
## 3739 2020-03-10 Australia -31.9505 115.8605     death     0      Q1
## 3740 2020-03-11 Australia -31.9505 115.8605     death     0      Q1
## 3741 2020-03-12 Australia -31.9505 115.8605     death     0      Q1
## 3742 2020-03-13 Australia -31.9505 115.8605     death     0      Q1
## 3743 2020-03-14 Australia -31.9505 115.8605     death     0      Q1
## 3744 2020-03-15 Australia -31.9505 115.8605     death     0      Q1
## 3745 2020-03-16 Australia -31.9505 115.8605     death     0      Q1
## 3746 2020-03-17 Australia -31.9505 115.8605     death     0      Q1
## 3747 2020-03-18 Australia -31.9505 115.8605     death     0      Q1
## 3748 2020-03-19 Australia -31.9505 115.8605     death     0      Q1
## 3749 2020-03-20 Australia -31.9505 115.8605     death     0      Q1
## 3750 2020-03-21 Australia -31.9505 115.8605     death     0      Q1
## 3751 2020-03-22 Australia -31.9505 115.8605     death     0      Q1
## 3752 2020-03-23 Australia -31.9505 115.8605     death     0      Q1
## 3753 2020-03-24 Australia -31.9505 115.8605     death     0      Q1
## 3754 2020-03-25 Australia -31.9505 115.8605     death     0      Q1
## 3755 2020-03-26 Australia -31.9505 115.8605     death     1      Q1
## 3756 2020-03-27 Australia -31.9505 115.8605     death     0      Q1
## 3757 2020-03-28 Australia -31.9505 115.8605     death     0      Q1
## 3758 2020-03-29 Australia -31.9505 115.8605     death     0      Q1
## 3759 2020-03-30 Australia -31.9505 115.8605     death     0      Q1
## 3760 2020-03-31 Australia -31.9505 115.8605     death     0      Q1
## 3937 2020-01-22 Australia -35.4735 149.0124 recovered     0      Q1
## 3938 2020-01-23 Australia -35.4735 149.0124 recovered     0      Q1
## 3939 2020-01-24 Australia -35.4735 149.0124 recovered     0      Q1
## 3940 2020-01-25 Australia -35.4735 149.0124 recovered     0      Q1
## 3941 2020-01-26 Australia -35.4735 149.0124 recovered     0      Q1
## 3942 2020-01-27 Australia -35.4735 149.0124 recovered     0      Q1
## 3943 2020-01-28 Australia -35.4735 149.0124 recovered     0      Q1
## 3944 2020-01-29 Australia -35.4735 149.0124 recovered     0      Q1
## 3945 2020-01-30 Australia -35.4735 149.0124 recovered     0      Q1
## 3946 2020-01-31 Australia -35.4735 149.0124 recovered     0      Q1
## 3947 2020-02-01 Australia -35.4735 149.0124 recovered     0      Q1
## 3948 2020-02-02 Australia -35.4735 149.0124 recovered     0      Q1
## 3949 2020-02-03 Australia -35.4735 149.0124 recovered     0      Q1
## 3950 2020-02-04 Australia -35.4735 149.0124 recovered     0      Q1
## 3951 2020-02-05 Australia -35.4735 149.0124 recovered     0      Q1
## 3952 2020-02-06 Australia -35.4735 149.0124 recovered     0      Q1
## 3953 2020-02-07 Australia -35.4735 149.0124 recovered     0      Q1
## 3954 2020-02-08 Australia -35.4735 149.0124 recovered     0      Q1
## 3955 2020-02-09 Australia -35.4735 149.0124 recovered     0      Q1
## 3956 2020-02-10 Australia -35.4735 149.0124 recovered     0      Q1
## 3957 2020-02-11 Australia -35.4735 149.0124 recovered     0      Q1
## 3958 2020-02-12 Australia -35.4735 149.0124 recovered     0      Q1
## 3959 2020-02-13 Australia -35.4735 149.0124 recovered     0      Q1
## 3960 2020-02-14 Australia -35.4735 149.0124 recovered     0      Q1
## 3961 2020-02-15 Australia -35.4735 149.0124 recovered     0      Q1
## 3962 2020-02-16 Australia -35.4735 149.0124 recovered     0      Q1
## 3963 2020-02-17 Australia -35.4735 149.0124 recovered     0      Q1
## 3964 2020-02-18 Australia -35.4735 149.0124 recovered     0      Q1
## 3965 2020-02-19 Australia -35.4735 149.0124 recovered     0      Q1
## 3966 2020-02-20 Australia -35.4735 149.0124 recovered     0      Q1
## 3967 2020-02-21 Australia -35.4735 149.0124 recovered     0      Q1
## 3968 2020-02-22 Australia -35.4735 149.0124 recovered     0      Q1
## 3969 2020-02-23 Australia -35.4735 149.0124 recovered     0      Q1
## 3970 2020-02-24 Australia -35.4735 149.0124 recovered     0      Q1
## 3971 2020-02-25 Australia -35.4735 149.0124 recovered     0      Q1
## 3972 2020-02-26 Australia -35.4735 149.0124 recovered     0      Q1
## 3973 2020-02-27 Australia -35.4735 149.0124 recovered     0      Q1
## 3974 2020-02-28 Australia -35.4735 149.0124 recovered     0      Q1
## 3975 2020-02-29 Australia -35.4735 149.0124 recovered     0      Q1
## 3976 2020-03-01 Australia -35.4735 149.0124 recovered     0      Q1
## 3977 2020-03-02 Australia -35.4735 149.0124 recovered     0      Q1
## 3978 2020-03-03 Australia -35.4735 149.0124 recovered     0      Q1
## 3979 2020-03-04 Australia -35.4735 149.0124 recovered     0      Q1
## 3980 2020-03-05 Australia -35.4735 149.0124 recovered     0      Q1
## 3981 2020-03-06 Australia -35.4735 149.0124 recovered     0      Q1
## 3982 2020-03-07 Australia -35.4735 149.0124 recovered     0      Q1
## 3983 2020-03-08 Australia -35.4735 149.0124 recovered     0      Q1
## 3984 2020-03-09 Australia -35.4735 149.0124 recovered     0      Q1
## 3985 2020-03-10 Australia -35.4735 149.0124 recovered     0      Q1
## 3986 2020-03-11 Australia -35.4735 149.0124 recovered     0      Q1
## 3987 2020-03-12 Australia -35.4735 149.0124 recovered     0      Q1
## 3988 2020-03-13 Australia -35.4735 149.0124 recovered     0      Q1
## 3989 2020-03-14 Australia -35.4735 149.0124 recovered     0      Q1
## 3990 2020-03-15 Australia -35.4735 149.0124 recovered     0      Q1
## 3991 2020-03-16 Australia -35.4735 149.0124 recovered     0      Q1
## 3992 2020-03-17 Australia -35.4735 149.0124 recovered     0      Q1
## 3993 2020-03-18 Australia -35.4735 149.0124 recovered     0      Q1
## 3994 2020-03-19 Australia -35.4735 149.0124 recovered     0      Q1
## 3995 2020-03-20 Australia -35.4735 149.0124 recovered     0      Q1
## 3996 2020-03-21 Australia -35.4735 149.0124 recovered     0      Q1
## 3997 2020-03-22 Australia -35.4735 149.0124 recovered     0      Q1
## 3998 2020-03-23 Australia -35.4735 149.0124 recovered     0      Q1
## 3999 2020-03-24 Australia -35.4735 149.0124 recovered     0      Q1
## 4000 2020-03-25 Australia -35.4735 149.0124 recovered     0      Q1
## 4001 2020-03-26 Australia -35.4735 149.0124 recovered     1      Q1
## 4002 2020-03-27 Australia -35.4735 149.0124 recovered     0      Q1
## 4003 2020-03-28 Australia -35.4735 149.0124 recovered     1      Q1
## 4004 2020-03-29 Australia -35.4735 149.0124 recovered     0      Q1
## 4005 2020-03-30 Australia -35.4735 149.0124 recovered     0      Q1
## 4006 2020-03-31 Australia -35.4735 149.0124 recovered     1      Q1
## 4183 2020-01-22 Australia -33.8688 151.2093 recovered     0      Q1
## 4184 2020-01-23 Australia -33.8688 151.2093 recovered     0      Q1
## 4185 2020-01-24 Australia -33.8688 151.2093 recovered     0      Q1
## 4186 2020-01-25 Australia -33.8688 151.2093 recovered     0      Q1
## 4187 2020-01-26 Australia -33.8688 151.2093 recovered     0      Q1
## 4188 2020-01-27 Australia -33.8688 151.2093 recovered     0      Q1
## 4189 2020-01-28 Australia -33.8688 151.2093 recovered     0      Q1
## 4190 2020-01-29 Australia -33.8688 151.2093 recovered     0      Q1
## 4191 2020-01-30 Australia -33.8688 151.2093 recovered     2      Q1
## 4192 2020-01-31 Australia -33.8688 151.2093 recovered     0      Q1
## 4193 2020-02-01 Australia -33.8688 151.2093 recovered     0      Q1
## 4194 2020-02-02 Australia -33.8688 151.2093 recovered     0      Q1
## 4195 2020-02-03 Australia -33.8688 151.2093 recovered     0      Q1
## 4196 2020-02-04 Australia -33.8688 151.2093 recovered     0      Q1
## 4197 2020-02-05 Australia -33.8688 151.2093 recovered     0      Q1
## 4198 2020-02-06 Australia -33.8688 151.2093 recovered     0      Q1
## 4199 2020-02-07 Australia -33.8688 151.2093 recovered     0      Q1
## 4200 2020-02-08 Australia -33.8688 151.2093 recovered     0      Q1
## 4201 2020-02-09 Australia -33.8688 151.2093 recovered     0      Q1
## 4202 2020-02-10 Australia -33.8688 151.2093 recovered     0      Q1
## 4203 2020-02-11 Australia -33.8688 151.2093 recovered     0      Q1
## 4204 2020-02-12 Australia -33.8688 151.2093 recovered     0      Q1
## 4205 2020-02-13 Australia -33.8688 151.2093 recovered     2      Q1
## 4206 2020-02-14 Australia -33.8688 151.2093 recovered     0      Q1
## 4207 2020-02-15 Australia -33.8688 151.2093 recovered     0      Q1
## 4208 2020-02-16 Australia -33.8688 151.2093 recovered     0      Q1
## 4209 2020-02-17 Australia -33.8688 151.2093 recovered     0      Q1
## 4210 2020-02-18 Australia -33.8688 151.2093 recovered     0      Q1
## 4211 2020-02-19 Australia -33.8688 151.2093 recovered     0      Q1
## 4212 2020-02-20 Australia -33.8688 151.2093 recovered     0      Q1
## 4213 2020-02-21 Australia -33.8688 151.2093 recovered     0      Q1
## 4214 2020-02-22 Australia -33.8688 151.2093 recovered     0      Q1
## 4215 2020-02-23 Australia -33.8688 151.2093 recovered     0      Q1
## 4216 2020-02-24 Australia -33.8688 151.2093 recovered     0      Q1
## 4217 2020-02-25 Australia -33.8688 151.2093 recovered     0      Q1
## 4218 2020-02-26 Australia -33.8688 151.2093 recovered     0      Q1
## 4219 2020-02-27 Australia -33.8688 151.2093 recovered     0      Q1
## 4220 2020-02-28 Australia -33.8688 151.2093 recovered     0      Q1
## 4221 2020-02-29 Australia -33.8688 151.2093 recovered     0      Q1
## 4222 2020-03-01 Australia -33.8688 151.2093 recovered     0      Q1
## 4223 2020-03-02 Australia -33.8688 151.2093 recovered     0      Q1
## 4224 2020-03-03 Australia -33.8688 151.2093 recovered     0      Q1
## 4225 2020-03-04 Australia -33.8688 151.2093 recovered     0      Q1
## 4226 2020-03-05 Australia -33.8688 151.2093 recovered     0      Q1
## 4227 2020-03-06 Australia -33.8688 151.2093 recovered     0      Q1
## 4228 2020-03-07 Australia -33.8688 151.2093 recovered     0      Q1
## 4229 2020-03-08 Australia -33.8688 151.2093 recovered     0      Q1
## 4230 2020-03-09 Australia -33.8688 151.2093 recovered     0      Q1
## 4231 2020-03-10 Australia -33.8688 151.2093 recovered     0      Q1
## 4232 2020-03-11 Australia -33.8688 151.2093 recovered     0      Q1
## 4233 2020-03-12 Australia -33.8688 151.2093 recovered     0      Q1
## 4234 2020-03-13 Australia -33.8688 151.2093 recovered     0      Q1
## 4235 2020-03-14 Australia -33.8688 151.2093 recovered     0      Q1
## 4236 2020-03-15 Australia -33.8688 151.2093 recovered     0      Q1
## 4237 2020-03-16 Australia -33.8688 151.2093 recovered     0      Q1
## 4238 2020-03-17 Australia -33.8688 151.2093 recovered     0      Q1
## 4239 2020-03-18 Australia -33.8688 151.2093 recovered     0      Q1
## 4240 2020-03-19 Australia -33.8688 151.2093 recovered     0      Q1
## 4241 2020-03-20 Australia -33.8688 151.2093 recovered     0      Q1
## 4242 2020-03-21 Australia -33.8688 151.2093 recovered     0      Q1
## 4243 2020-03-22 Australia -33.8688 151.2093 recovered     0      Q1
## 4244 2020-03-23 Australia -33.8688 151.2093 recovered     0      Q1
## 4245 2020-03-24 Australia -33.8688 151.2093 recovered     0      Q1
## 4246 2020-03-25 Australia -33.8688 151.2093 recovered     0      Q1
## 4247 2020-03-26 Australia -33.8688 151.2093 recovered     0      Q1
## 4248 2020-03-27 Australia -33.8688 151.2093 recovered     0      Q1
## 4249 2020-03-28 Australia -33.8688 151.2093 recovered     0      Q1
## 4250 2020-03-29 Australia -33.8688 151.2093 recovered     0      Q1
## 4251 2020-03-30 Australia -33.8688 151.2093 recovered     0      Q1
## 4252 2020-03-31 Australia -33.8688 151.2093 recovered     0      Q1
## 4429 2020-01-22 Australia -12.4634 130.8456 recovered     0      Q1
## 4430 2020-01-23 Australia -12.4634 130.8456 recovered     0      Q1
## 4431 2020-01-24 Australia -12.4634 130.8456 recovered     0      Q1
## 4432 2020-01-25 Australia -12.4634 130.8456 recovered     0      Q1
## 4433 2020-01-26 Australia -12.4634 130.8456 recovered     0      Q1
## 4434 2020-01-27 Australia -12.4634 130.8456 recovered     0      Q1
## 4435 2020-01-28 Australia -12.4634 130.8456 recovered     0      Q1
## 4436 2020-01-29 Australia -12.4634 130.8456 recovered     0      Q1
## 4437 2020-01-30 Australia -12.4634 130.8456 recovered     0      Q1
## 4438 2020-01-31 Australia -12.4634 130.8456 recovered     0      Q1
## 4439 2020-02-01 Australia -12.4634 130.8456 recovered     0      Q1
## 4440 2020-02-02 Australia -12.4634 130.8456 recovered     0      Q1
## 4441 2020-02-03 Australia -12.4634 130.8456 recovered     0      Q1
## 4442 2020-02-04 Australia -12.4634 130.8456 recovered     0      Q1
## 4443 2020-02-05 Australia -12.4634 130.8456 recovered     0      Q1
## 4444 2020-02-06 Australia -12.4634 130.8456 recovered     0      Q1
## 4445 2020-02-07 Australia -12.4634 130.8456 recovered     0      Q1
## 4446 2020-02-08 Australia -12.4634 130.8456 recovered     0      Q1
## 4447 2020-02-09 Australia -12.4634 130.8456 recovered     0      Q1
## 4448 2020-02-10 Australia -12.4634 130.8456 recovered     0      Q1
## 4449 2020-02-11 Australia -12.4634 130.8456 recovered     0      Q1
## 4450 2020-02-12 Australia -12.4634 130.8456 recovered     0      Q1
## 4451 2020-02-13 Australia -12.4634 130.8456 recovered     0      Q1
## 4452 2020-02-14 Australia -12.4634 130.8456 recovered     0      Q1
## 4453 2020-02-15 Australia -12.4634 130.8456 recovered     0      Q1
## 4454 2020-02-16 Australia -12.4634 130.8456 recovered     0      Q1
## 4455 2020-02-17 Australia -12.4634 130.8456 recovered     0      Q1
## 4456 2020-02-18 Australia -12.4634 130.8456 recovered     0      Q1
## 4457 2020-02-19 Australia -12.4634 130.8456 recovered     0      Q1
## 4458 2020-02-20 Australia -12.4634 130.8456 recovered     0      Q1
## 4459 2020-02-21 Australia -12.4634 130.8456 recovered     0      Q1
## 4460 2020-02-22 Australia -12.4634 130.8456 recovered     0      Q1
## 4461 2020-02-23 Australia -12.4634 130.8456 recovered     0      Q1
## 4462 2020-02-24 Australia -12.4634 130.8456 recovered     0      Q1
## 4463 2020-02-25 Australia -12.4634 130.8456 recovered     0      Q1
## 4464 2020-02-26 Australia -12.4634 130.8456 recovered     0      Q1
## 4465 2020-02-27 Australia -12.4634 130.8456 recovered     0      Q1
## 4466 2020-02-28 Australia -12.4634 130.8456 recovered     0      Q1
## 4467 2020-02-29 Australia -12.4634 130.8456 recovered     0      Q1
## 4468 2020-03-01 Australia -12.4634 130.8456 recovered     0      Q1
## 4469 2020-03-02 Australia -12.4634 130.8456 recovered     0      Q1
## 4470 2020-03-03 Australia -12.4634 130.8456 recovered     0      Q1
## 4471 2020-03-04 Australia -12.4634 130.8456 recovered     0      Q1
## 4472 2020-03-05 Australia -12.4634 130.8456 recovered     0      Q1
## 4473 2020-03-06 Australia -12.4634 130.8456 recovered     0      Q1
## 4474 2020-03-07 Australia -12.4634 130.8456 recovered     0      Q1
## 4475 2020-03-08 Australia -12.4634 130.8456 recovered     0      Q1
## 4476 2020-03-09 Australia -12.4634 130.8456 recovered     0      Q1
## 4477 2020-03-10 Australia -12.4634 130.8456 recovered     0      Q1
## 4478 2020-03-11 Australia -12.4634 130.8456 recovered     0      Q1
## 4479 2020-03-12 Australia -12.4634 130.8456 recovered     0      Q1
## 4480 2020-03-13 Australia -12.4634 130.8456 recovered     0      Q1
## 4481 2020-03-14 Australia -12.4634 130.8456 recovered     0      Q1
## 4482 2020-03-15 Australia -12.4634 130.8456 recovered     0      Q1
## 4483 2020-03-16 Australia -12.4634 130.8456 recovered     0      Q1
## 4484 2020-03-17 Australia -12.4634 130.8456 recovered     0      Q1
## 4485 2020-03-18 Australia -12.4634 130.8456 recovered     0      Q1
## 4486 2020-03-19 Australia -12.4634 130.8456 recovered     0      Q1
## 4487 2020-03-20 Australia -12.4634 130.8456 recovered     0      Q1
## 4488 2020-03-21 Australia -12.4634 130.8456 recovered     0      Q1
## 4489 2020-03-22 Australia -12.4634 130.8456 recovered     0      Q1
## 4490 2020-03-23 Australia -12.4634 130.8456 recovered     0      Q1
## 4491 2020-03-24 Australia -12.4634 130.8456 recovered     0      Q1
## 4492 2020-03-25 Australia -12.4634 130.8456 recovered     0      Q1
## 4493 2020-03-26 Australia -12.4634 130.8456 recovered     0      Q1
## 4494 2020-03-27 Australia -12.4634 130.8456 recovered     0      Q1
## 4495 2020-03-28 Australia -12.4634 130.8456 recovered     0      Q1
## 4496 2020-03-29 Australia -12.4634 130.8456 recovered     0      Q1
## 4497 2020-03-30 Australia -12.4634 130.8456 recovered     0      Q1
## 4498 2020-03-31 Australia -12.4634 130.8456 recovered     0      Q1
## 4675 2020-01-22 Australia -27.4698 153.0251 recovered     0      Q1
## 4676 2020-01-23 Australia -27.4698 153.0251 recovered     0      Q1
## 4677 2020-01-24 Australia -27.4698 153.0251 recovered     0      Q1
## 4678 2020-01-25 Australia -27.4698 153.0251 recovered     0      Q1
## 4679 2020-01-26 Australia -27.4698 153.0251 recovered     0      Q1
## 4680 2020-01-27 Australia -27.4698 153.0251 recovered     0      Q1
## 4681 2020-01-28 Australia -27.4698 153.0251 recovered     0      Q1
## 4682 2020-01-29 Australia -27.4698 153.0251 recovered     0      Q1
## 4683 2020-01-30 Australia -27.4698 153.0251 recovered     0      Q1
## 4684 2020-01-31 Australia -27.4698 153.0251 recovered     0      Q1
## 4685 2020-02-01 Australia -27.4698 153.0251 recovered     0      Q1
## 4686 2020-02-02 Australia -27.4698 153.0251 recovered     0      Q1
## 4687 2020-02-03 Australia -27.4698 153.0251 recovered     0      Q1
## 4688 2020-02-04 Australia -27.4698 153.0251 recovered     0      Q1
## 4689 2020-02-05 Australia -27.4698 153.0251 recovered     0      Q1
## 4690 2020-02-06 Australia -27.4698 153.0251 recovered     0      Q1
## 4691 2020-02-07 Australia -27.4698 153.0251 recovered     0      Q1
## 4692 2020-02-08 Australia -27.4698 153.0251 recovered     0      Q1
## 4693 2020-02-09 Australia -27.4698 153.0251 recovered     0      Q1
## 4694 2020-02-10 Australia -27.4698 153.0251 recovered     0      Q1
## 4695 2020-02-11 Australia -27.4698 153.0251 recovered     0      Q1
## 4696 2020-02-12 Australia -27.4698 153.0251 recovered     0      Q1
## 4697 2020-02-13 Australia -27.4698 153.0251 recovered     0      Q1
## 4698 2020-02-14 Australia -27.4698 153.0251 recovered     0      Q1
## 4699 2020-02-15 Australia -27.4698 153.0251 recovered     0      Q1
## 4700 2020-02-16 Australia -27.4698 153.0251 recovered     0      Q1
## 4701 2020-02-17 Australia -27.4698 153.0251 recovered     0      Q1
## 4702 2020-02-18 Australia -27.4698 153.0251 recovered     0      Q1
## 4703 2020-02-19 Australia -27.4698 153.0251 recovered     0      Q1
## 4704 2020-02-20 Australia -27.4698 153.0251 recovered     0      Q1
## 4705 2020-02-21 Australia -27.4698 153.0251 recovered     1      Q1
## 4706 2020-02-22 Australia -27.4698 153.0251 recovered     0      Q1
## 4707 2020-02-23 Australia -27.4698 153.0251 recovered     0      Q1
## 4708 2020-02-24 Australia -27.4698 153.0251 recovered     0      Q1
## 4709 2020-02-25 Australia -27.4698 153.0251 recovered     0      Q1
## 4710 2020-02-26 Australia -27.4698 153.0251 recovered     0      Q1
## 4711 2020-02-27 Australia -27.4698 153.0251 recovered     0      Q1
## 4712 2020-02-28 Australia -27.4698 153.0251 recovered     0      Q1
## 4713 2020-02-29 Australia -27.4698 153.0251 recovered     0      Q1
## 4714 2020-03-01 Australia -27.4698 153.0251 recovered     0      Q1
## 4715 2020-03-02 Australia -27.4698 153.0251 recovered     0      Q1
## 4716 2020-03-03 Australia -27.4698 153.0251 recovered     0      Q1
## 4717 2020-03-04 Australia -27.4698 153.0251 recovered     0      Q1
## 4718 2020-03-05 Australia -27.4698 153.0251 recovered     7      Q1
## 4719 2020-03-06 Australia -27.4698 153.0251 recovered     0      Q1
## 4720 2020-03-07 Australia -27.4698 153.0251 recovered     0      Q1
## 4721 2020-03-08 Australia -27.4698 153.0251 recovered     0      Q1
## 4722 2020-03-09 Australia -27.4698 153.0251 recovered     0      Q1
## 4723 2020-03-10 Australia -27.4698 153.0251 recovered     0      Q1
## 4724 2020-03-11 Australia -27.4698 153.0251 recovered     0      Q1
## 4725 2020-03-12 Australia -27.4698 153.0251 recovered     0      Q1
## 4726 2020-03-13 Australia -27.4698 153.0251 recovered     0      Q1
## 4727 2020-03-14 Australia -27.4698 153.0251 recovered     0      Q1
## 4728 2020-03-15 Australia -27.4698 153.0251 recovered     0      Q1
## 4729 2020-03-16 Australia -27.4698 153.0251 recovered     0      Q1
## 4730 2020-03-17 Australia -27.4698 153.0251 recovered     0      Q1
## 4731 2020-03-18 Australia -27.4698 153.0251 recovered     0      Q1
## 4732 2020-03-19 Australia -27.4698 153.0251 recovered     0      Q1
## 4733 2020-03-20 Australia -27.4698 153.0251 recovered     0      Q1
## 4734 2020-03-21 Australia -27.4698 153.0251 recovered     0      Q1
## 4735 2020-03-22 Australia -27.4698 153.0251 recovered     0      Q1
## 4736 2020-03-23 Australia -27.4698 153.0251 recovered     0      Q1
## 4737 2020-03-24 Australia -27.4698 153.0251 recovered     0      Q1
## 4738 2020-03-25 Australia -27.4698 153.0251 recovered     0      Q1
## 4739 2020-03-26 Australia -27.4698 153.0251 recovered     0      Q1
## 4740 2020-03-27 Australia -27.4698 153.0251 recovered     0      Q1
## 4741 2020-03-28 Australia -27.4698 153.0251 recovered     0      Q1
## 4742 2020-03-29 Australia -27.4698 153.0251 recovered     0      Q1
## 4743 2020-03-30 Australia -27.4698 153.0251 recovered     0      Q1
## 4744 2020-03-31 Australia -27.4698 153.0251 recovered     0      Q1
## 4921 2020-01-22 Australia -34.9285 138.6007 recovered     0      Q1
## 4922 2020-01-23 Australia -34.9285 138.6007 recovered     0      Q1
## 4923 2020-01-24 Australia -34.9285 138.6007 recovered     0      Q1
## 4924 2020-01-25 Australia -34.9285 138.6007 recovered     0      Q1
## 4925 2020-01-26 Australia -34.9285 138.6007 recovered     0      Q1
## 4926 2020-01-27 Australia -34.9285 138.6007 recovered     0      Q1
## 4927 2020-01-28 Australia -34.9285 138.6007 recovered     0      Q1
## 4928 2020-01-29 Australia -34.9285 138.6007 recovered     0      Q1
## 4929 2020-01-30 Australia -34.9285 138.6007 recovered     0      Q1
## 4930 2020-01-31 Australia -34.9285 138.6007 recovered     0      Q1
## 4931 2020-02-01 Australia -34.9285 138.6007 recovered     0      Q1
## 4932 2020-02-02 Australia -34.9285 138.6007 recovered     0      Q1
## 4933 2020-02-03 Australia -34.9285 138.6007 recovered     0      Q1
## 4934 2020-02-04 Australia -34.9285 138.6007 recovered     0      Q1
## 4935 2020-02-05 Australia -34.9285 138.6007 recovered     0      Q1
## 4936 2020-02-06 Australia -34.9285 138.6007 recovered     0      Q1
## 4937 2020-02-07 Australia -34.9285 138.6007 recovered     0      Q1
## 4938 2020-02-08 Australia -34.9285 138.6007 recovered     0      Q1
## 4939 2020-02-09 Australia -34.9285 138.6007 recovered     0      Q1
## 4940 2020-02-10 Australia -34.9285 138.6007 recovered     0      Q1
## 4941 2020-02-11 Australia -34.9285 138.6007 recovered     0      Q1
## 4942 2020-02-12 Australia -34.9285 138.6007 recovered     0      Q1
## 4943 2020-02-13 Australia -34.9285 138.6007 recovered     0      Q1
## 4944 2020-02-14 Australia -34.9285 138.6007 recovered     0      Q1
## 4945 2020-02-15 Australia -34.9285 138.6007 recovered     0      Q1
## 4946 2020-02-16 Australia -34.9285 138.6007 recovered     0      Q1
## 4947 2020-02-17 Australia -34.9285 138.6007 recovered     2      Q1
## 4948 2020-02-18 Australia -34.9285 138.6007 recovered     0      Q1
## 4949 2020-02-19 Australia -34.9285 138.6007 recovered     0      Q1
## 4950 2020-02-20 Australia -34.9285 138.6007 recovered     0      Q1
## 4951 2020-02-21 Australia -34.9285 138.6007 recovered     0      Q1
## 4952 2020-02-22 Australia -34.9285 138.6007 recovered     0      Q1
## 4953 2020-02-23 Australia -34.9285 138.6007 recovered     0      Q1
## 4954 2020-02-24 Australia -34.9285 138.6007 recovered     0      Q1
## 4955 2020-02-25 Australia -34.9285 138.6007 recovered     0      Q1
## 4956 2020-02-26 Australia -34.9285 138.6007 recovered     0      Q1
## 4957 2020-02-27 Australia -34.9285 138.6007 recovered     0      Q1
## 4958 2020-02-28 Australia -34.9285 138.6007 recovered     0      Q1
## 4959 2020-02-29 Australia -34.9285 138.6007 recovered     0      Q1
## 4960 2020-03-01 Australia -34.9285 138.6007 recovered     0      Q1
## 4961 2020-03-02 Australia -34.9285 138.6007 recovered     0      Q1
## 4962 2020-03-03 Australia -34.9285 138.6007 recovered     0      Q1
## 4963 2020-03-04 Australia -34.9285 138.6007 recovered     0      Q1
## 4964 2020-03-05 Australia -34.9285 138.6007 recovered     0      Q1
## 4965 2020-03-06 Australia -34.9285 138.6007 recovered     0      Q1
## 4966 2020-03-07 Australia -34.9285 138.6007 recovered     0      Q1
## 4967 2020-03-08 Australia -34.9285 138.6007 recovered     0      Q1
## 4968 2020-03-09 Australia -34.9285 138.6007 recovered     0      Q1
## 4969 2020-03-10 Australia -34.9285 138.6007 recovered     0      Q1
## 4970 2020-03-11 Australia -34.9285 138.6007 recovered     0      Q1
## 4971 2020-03-12 Australia -34.9285 138.6007 recovered     0      Q1
## 4972 2020-03-13 Australia -34.9285 138.6007 recovered     1      Q1
## 4973 2020-03-14 Australia -34.9285 138.6007 recovered     0      Q1
## 4974 2020-03-15 Australia -34.9285 138.6007 recovered     0      Q1
## 4975 2020-03-16 Australia -34.9285 138.6007 recovered     0      Q1
## 4976 2020-03-17 Australia -34.9285 138.6007 recovered     0      Q1
## 4977 2020-03-18 Australia -34.9285 138.6007 recovered     0      Q1
## 4978 2020-03-19 Australia -34.9285 138.6007 recovered     0      Q1
## 4979 2020-03-20 Australia -34.9285 138.6007 recovered     0      Q1
## 4980 2020-03-21 Australia -34.9285 138.6007 recovered     0      Q1
## 4981 2020-03-22 Australia -34.9285 138.6007 recovered     0      Q1
## 4982 2020-03-23 Australia -34.9285 138.6007 recovered     0      Q1
## 4983 2020-03-24 Australia -34.9285 138.6007 recovered     0      Q1
## 4984 2020-03-25 Australia -34.9285 138.6007 recovered     3      Q1
## 4985 2020-03-26 Australia -34.9285 138.6007 recovered     0      Q1
## 4986 2020-03-27 Australia -34.9285 138.6007 recovered     0      Q1
## 4987 2020-03-28 Australia -34.9285 138.6007 recovered     0      Q1
## 4988 2020-03-29 Australia -34.9285 138.6007 recovered     0      Q1
## 4989 2020-03-30 Australia -34.9285 138.6007 recovered     0      Q1
## 4990 2020-03-31 Australia -34.9285 138.6007 recovered     0      Q1
## 5167 2020-01-22 Australia -42.8821 147.3272 recovered     0      Q1
## 5168 2020-01-23 Australia -42.8821 147.3272 recovered     0      Q1
## 5169 2020-01-24 Australia -42.8821 147.3272 recovered     0      Q1
## 5170 2020-01-25 Australia -42.8821 147.3272 recovered     0      Q1
## 5171 2020-01-26 Australia -42.8821 147.3272 recovered     0      Q1
## 5172 2020-01-27 Australia -42.8821 147.3272 recovered     0      Q1
## 5173 2020-01-28 Australia -42.8821 147.3272 recovered     0      Q1
## 5174 2020-01-29 Australia -42.8821 147.3272 recovered     0      Q1
## 5175 2020-01-30 Australia -42.8821 147.3272 recovered     0      Q1
## 5176 2020-01-31 Australia -42.8821 147.3272 recovered     0      Q1
## 5177 2020-02-01 Australia -42.8821 147.3272 recovered     0      Q1
## 5178 2020-02-02 Australia -42.8821 147.3272 recovered     0      Q1
## 5179 2020-02-03 Australia -42.8821 147.3272 recovered     0      Q1
## 5180 2020-02-04 Australia -42.8821 147.3272 recovered     0      Q1
## 5181 2020-02-05 Australia -42.8821 147.3272 recovered     0      Q1
## 5182 2020-02-06 Australia -42.8821 147.3272 recovered     0      Q1
## 5183 2020-02-07 Australia -42.8821 147.3272 recovered     0      Q1
## 5184 2020-02-08 Australia -42.8821 147.3272 recovered     0      Q1
## 5185 2020-02-09 Australia -42.8821 147.3272 recovered     0      Q1
## 5186 2020-02-10 Australia -42.8821 147.3272 recovered     0      Q1
## 5187 2020-02-11 Australia -42.8821 147.3272 recovered     0      Q1
## 5188 2020-02-12 Australia -42.8821 147.3272 recovered     0      Q1
## 5189 2020-02-13 Australia -42.8821 147.3272 recovered     0      Q1
## 5190 2020-02-14 Australia -42.8821 147.3272 recovered     0      Q1
## 5191 2020-02-15 Australia -42.8821 147.3272 recovered     0      Q1
## 5192 2020-02-16 Australia -42.8821 147.3272 recovered     0      Q1
## 5193 2020-02-17 Australia -42.8821 147.3272 recovered     0      Q1
## 5194 2020-02-18 Australia -42.8821 147.3272 recovered     0      Q1
## 5195 2020-02-19 Australia -42.8821 147.3272 recovered     0      Q1
## 5196 2020-02-20 Australia -42.8821 147.3272 recovered     0      Q1
## 5197 2020-02-21 Australia -42.8821 147.3272 recovered     0      Q1
## 5198 2020-02-22 Australia -42.8821 147.3272 recovered     0      Q1
## 5199 2020-02-23 Australia -42.8821 147.3272 recovered     0      Q1
## 5200 2020-02-24 Australia -42.8821 147.3272 recovered     0      Q1
## 5201 2020-02-25 Australia -42.8821 147.3272 recovered     0      Q1
## 5202 2020-02-26 Australia -42.8821 147.3272 recovered     0      Q1
## 5203 2020-02-27 Australia -42.8821 147.3272 recovered     0      Q1
## 5204 2020-02-28 Australia -42.8821 147.3272 recovered     0      Q1
## 5205 2020-02-29 Australia -42.8821 147.3272 recovered     0      Q1
## 5206 2020-03-01 Australia -42.8821 147.3272 recovered     0      Q1
## 5207 2020-03-02 Australia -42.8821 147.3272 recovered     0      Q1
## 5208 2020-03-03 Australia -42.8821 147.3272 recovered     0      Q1
## 5209 2020-03-04 Australia -42.8821 147.3272 recovered     0      Q1
## 5210 2020-03-05 Australia -42.8821 147.3272 recovered     0      Q1
## 5211 2020-03-06 Australia -42.8821 147.3272 recovered     0      Q1
## 5212 2020-03-07 Australia -42.8821 147.3272 recovered     0      Q1
## 5213 2020-03-08 Australia -42.8821 147.3272 recovered     0      Q1
## 5214 2020-03-09 Australia -42.8821 147.3272 recovered     0      Q1
## 5215 2020-03-10 Australia -42.8821 147.3272 recovered     0      Q1
## 5216 2020-03-11 Australia -42.8821 147.3272 recovered     0      Q1
## 5217 2020-03-12 Australia -42.8821 147.3272 recovered     0      Q1
## 5218 2020-03-13 Australia -42.8821 147.3272 recovered     0      Q1
## 5219 2020-03-14 Australia -42.8821 147.3272 recovered     0      Q1
## 5220 2020-03-15 Australia -42.8821 147.3272 recovered     0      Q1
## 5221 2020-03-16 Australia -42.8821 147.3272 recovered     0      Q1
## 5222 2020-03-17 Australia -42.8821 147.3272 recovered     0      Q1
## 5223 2020-03-18 Australia -42.8821 147.3272 recovered     0      Q1
## 5224 2020-03-19 Australia -42.8821 147.3272 recovered     3      Q1
## 5225 2020-03-20 Australia -42.8821 147.3272 recovered     0      Q1
## 5226 2020-03-21 Australia -42.8821 147.3272 recovered     0      Q1
## 5227 2020-03-22 Australia -42.8821 147.3272 recovered     0      Q1
## 5228 2020-03-23 Australia -42.8821 147.3272 recovered     0      Q1
## 5229 2020-03-24 Australia -42.8821 147.3272 recovered     0      Q1
## 5230 2020-03-25 Australia -42.8821 147.3272 recovered     0      Q1
## 5231 2020-03-26 Australia -42.8821 147.3272 recovered     0      Q1
## 5232 2020-03-27 Australia -42.8821 147.3272 recovered     0      Q1
## 5233 2020-03-28 Australia -42.8821 147.3272 recovered     2      Q1
## 5234 2020-03-29 Australia -42.8821 147.3272 recovered     0      Q1
## 5235 2020-03-30 Australia -42.8821 147.3272 recovered     0      Q1
## 5236 2020-03-31 Australia -42.8821 147.3272 recovered     0      Q1
## 5413 2020-01-22 Australia -37.8136 144.9631 recovered     0      Q1
## 5414 2020-01-23 Australia -37.8136 144.9631 recovered     0      Q1
## 5415 2020-01-24 Australia -37.8136 144.9631 recovered     0      Q1
## 5416 2020-01-25 Australia -37.8136 144.9631 recovered     0      Q1
## 5417 2020-01-26 Australia -37.8136 144.9631 recovered     0      Q1
## 5418 2020-01-27 Australia -37.8136 144.9631 recovered     0      Q1
## 5419 2020-01-28 Australia -37.8136 144.9631 recovered     0      Q1
## 5420 2020-01-29 Australia -37.8136 144.9631 recovered     0      Q1
## 5421 2020-01-30 Australia -37.8136 144.9631 recovered     0      Q1
## 5422 2020-01-31 Australia -37.8136 144.9631 recovered     0      Q1
## 5423 2020-02-01 Australia -37.8136 144.9631 recovered     0      Q1
## 5424 2020-02-02 Australia -37.8136 144.9631 recovered     0      Q1
## 5425 2020-02-03 Australia -37.8136 144.9631 recovered     0      Q1
## 5426 2020-02-04 Australia -37.8136 144.9631 recovered     0      Q1
## 5427 2020-02-05 Australia -37.8136 144.9631 recovered     0      Q1
## 5428 2020-02-06 Australia -37.8136 144.9631 recovered     0      Q1
## 5429 2020-02-07 Australia -37.8136 144.9631 recovered     0      Q1
## 5430 2020-02-08 Australia -37.8136 144.9631 recovered     0      Q1
## 5431 2020-02-09 Australia -37.8136 144.9631 recovered     0      Q1
## 5432 2020-02-10 Australia -37.8136 144.9631 recovered     0      Q1
## 5433 2020-02-11 Australia -37.8136 144.9631 recovered     0      Q1
## 5434 2020-02-12 Australia -37.8136 144.9631 recovered     0      Q1
## 5435 2020-02-13 Australia -37.8136 144.9631 recovered     4      Q1
## 5436 2020-02-14 Australia -37.8136 144.9631 recovered     0      Q1
## 5437 2020-02-15 Australia -37.8136 144.9631 recovered     0      Q1
## 5438 2020-02-16 Australia -37.8136 144.9631 recovered     0      Q1
## 5439 2020-02-17 Australia -37.8136 144.9631 recovered     0      Q1
## 5440 2020-02-18 Australia -37.8136 144.9631 recovered     0      Q1
## 5441 2020-02-19 Australia -37.8136 144.9631 recovered     0      Q1
## 5442 2020-02-20 Australia -37.8136 144.9631 recovered     0      Q1
## 5443 2020-02-21 Australia -37.8136 144.9631 recovered     0      Q1
## 5444 2020-02-22 Australia -37.8136 144.9631 recovered     0      Q1
## 5445 2020-02-23 Australia -37.8136 144.9631 recovered     0      Q1
## 5446 2020-02-24 Australia -37.8136 144.9631 recovered     0      Q1
## 5447 2020-02-25 Australia -37.8136 144.9631 recovered     0      Q1
## 5448 2020-02-26 Australia -37.8136 144.9631 recovered     0      Q1
## 5449 2020-02-27 Australia -37.8136 144.9631 recovered     0      Q1
## 5450 2020-02-28 Australia -37.8136 144.9631 recovered     0      Q1
## 5451 2020-02-29 Australia -37.8136 144.9631 recovered     0      Q1
## 5452 2020-03-01 Australia -37.8136 144.9631 recovered     0      Q1
## 5453 2020-03-02 Australia -37.8136 144.9631 recovered     0      Q1
## 5454 2020-03-03 Australia -37.8136 144.9631 recovered     0      Q1
## 5455 2020-03-04 Australia -37.8136 144.9631 recovered     0      Q1
## 5456 2020-03-05 Australia -37.8136 144.9631 recovered     3      Q1
## 5457 2020-03-06 Australia -37.8136 144.9631 recovered     0      Q1
## 5458 2020-03-07 Australia -37.8136 144.9631 recovered     0      Q1
## 5459 2020-03-08 Australia -37.8136 144.9631 recovered     0      Q1
## 5460 2020-03-09 Australia -37.8136 144.9631 recovered     0      Q1
## 5461 2020-03-10 Australia -37.8136 144.9631 recovered     0      Q1
## 5462 2020-03-11 Australia -37.8136 144.9631 recovered     0      Q1
## 5463 2020-03-12 Australia -37.8136 144.9631 recovered     0      Q1
## 5464 2020-03-13 Australia -37.8136 144.9631 recovered     1      Q1
## 5465 2020-03-14 Australia -37.8136 144.9631 recovered     0      Q1
## 5466 2020-03-15 Australia -37.8136 144.9631 recovered     0      Q1
## 5467 2020-03-16 Australia -37.8136 144.9631 recovered     0      Q1
## 5468 2020-03-17 Australia -37.8136 144.9631 recovered     0      Q1
## 5469 2020-03-18 Australia -37.8136 144.9631 recovered     0      Q1
## 5470 2020-03-19 Australia -37.8136 144.9631 recovered     0      Q1
## 5471 2020-03-20 Australia -37.8136 144.9631 recovered     0      Q1
## 5472 2020-03-21 Australia -37.8136 144.9631 recovered     0      Q1
## 5473 2020-03-22 Australia -37.8136 144.9631 recovered    62      Q1
## 5474 2020-03-23 Australia -37.8136 144.9631 recovered     0      Q1
## 5475 2020-03-24 Australia -37.8136 144.9631 recovered    27      Q1
## 5476 2020-03-25 Australia -37.8136 144.9631 recovered     0      Q1
## 5477 2020-03-26 Australia -37.8136 144.9631 recovered    52      Q1
## 5478 2020-03-27 Australia -37.8136 144.9631 recovered    22      Q1
## 5479 2020-03-28 Australia -37.8136 144.9631 recovered    20      Q1
## 5480 2020-03-29 Australia -37.8136 144.9631 recovered     0      Q1
## 5481 2020-03-30 Australia -37.8136 144.9631 recovered     0      Q1
## 5482 2020-03-31 Australia -37.8136 144.9631 recovered   100      Q1
## 5659 2020-01-22 Australia -31.9505 115.8605 recovered     0      Q1
## 5660 2020-01-23 Australia -31.9505 115.8605 recovered     0      Q1
## 5661 2020-01-24 Australia -31.9505 115.8605 recovered     0      Q1
## 5662 2020-01-25 Australia -31.9505 115.8605 recovered     0      Q1
## 5663 2020-01-26 Australia -31.9505 115.8605 recovered     0      Q1
## 5664 2020-01-27 Australia -31.9505 115.8605 recovered     0      Q1
## 5665 2020-01-28 Australia -31.9505 115.8605 recovered     0      Q1
## 5666 2020-01-29 Australia -31.9505 115.8605 recovered     0      Q1
## 5667 2020-01-30 Australia -31.9505 115.8605 recovered     0      Q1
## 5668 2020-01-31 Australia -31.9505 115.8605 recovered     0      Q1
## 5669 2020-02-01 Australia -31.9505 115.8605 recovered     0      Q1
## 5670 2020-02-02 Australia -31.9505 115.8605 recovered     0      Q1
## 5671 2020-02-03 Australia -31.9505 115.8605 recovered     0      Q1
## 5672 2020-02-04 Australia -31.9505 115.8605 recovered     0      Q1
## 5673 2020-02-05 Australia -31.9505 115.8605 recovered     0      Q1
## 5674 2020-02-06 Australia -31.9505 115.8605 recovered     0      Q1
## 5675 2020-02-07 Australia -31.9505 115.8605 recovered     0      Q1
## 5676 2020-02-08 Australia -31.9505 115.8605 recovered     0      Q1
## 5677 2020-02-09 Australia -31.9505 115.8605 recovered     0      Q1
## 5678 2020-02-10 Australia -31.9505 115.8605 recovered     0      Q1
## 5679 2020-02-11 Australia -31.9505 115.8605 recovered     0      Q1
## 5680 2020-02-12 Australia -31.9505 115.8605 recovered     0      Q1
## 5681 2020-02-13 Australia -31.9505 115.8605 recovered     0      Q1
## 5682 2020-02-14 Australia -31.9505 115.8605 recovered     0      Q1
## 5683 2020-02-15 Australia -31.9505 115.8605 recovered     0      Q1
## 5684 2020-02-16 Australia -31.9505 115.8605 recovered     0      Q1
## 5685 2020-02-17 Australia -31.9505 115.8605 recovered     0      Q1
## 5686 2020-02-18 Australia -31.9505 115.8605 recovered     0      Q1
## 5687 2020-02-19 Australia -31.9505 115.8605 recovered     0      Q1
## 5688 2020-02-20 Australia -31.9505 115.8605 recovered     0      Q1
## 5689 2020-02-21 Australia -31.9505 115.8605 recovered     0      Q1
## 5690 2020-02-22 Australia -31.9505 115.8605 recovered     0      Q1
## 5691 2020-02-23 Australia -31.9505 115.8605 recovered     0      Q1
## 5692 2020-02-24 Australia -31.9505 115.8605 recovered     0      Q1
## 5693 2020-02-25 Australia -31.9505 115.8605 recovered     0      Q1
## 5694 2020-02-26 Australia -31.9505 115.8605 recovered     0      Q1
## 5695 2020-02-27 Australia -31.9505 115.8605 recovered     0      Q1
## 5696 2020-02-28 Australia -31.9505 115.8605 recovered     0      Q1
## 5697 2020-02-29 Australia -31.9505 115.8605 recovered     0      Q1
## 5698 2020-03-01 Australia -31.9505 115.8605 recovered     0      Q1
## 5699 2020-03-02 Australia -31.9505 115.8605 recovered     0      Q1
## 5700 2020-03-03 Australia -31.9505 115.8605 recovered     0      Q1
## 5701 2020-03-04 Australia -31.9505 115.8605 recovered     0      Q1
## 5702 2020-03-05 Australia -31.9505 115.8605 recovered     0      Q1
## 5703 2020-03-06 Australia -31.9505 115.8605 recovered     0      Q1
## 5704 2020-03-07 Australia -31.9505 115.8605 recovered     0      Q1
## 5705 2020-03-08 Australia -31.9505 115.8605 recovered     0      Q1
## 5706 2020-03-09 Australia -31.9505 115.8605 recovered     0      Q1
## 5707 2020-03-10 Australia -31.9505 115.8605 recovered     0      Q1
## 5708 2020-03-11 Australia -31.9505 115.8605 recovered     0      Q1
## 5709 2020-03-12 Australia -31.9505 115.8605 recovered     0      Q1
## 5710 2020-03-13 Australia -31.9505 115.8605 recovered     0      Q1
## 5711 2020-03-14 Australia -31.9505 115.8605 recovered     0      Q1
## 5712 2020-03-15 Australia -31.9505 115.8605 recovered     0      Q1
## 5713 2020-03-16 Australia -31.9505 115.8605 recovered     0      Q1
## 5714 2020-03-17 Australia -31.9505 115.8605 recovered     0      Q1
## 5715 2020-03-18 Australia -31.9505 115.8605 recovered     0      Q1
## 5716 2020-03-19 Australia -31.9505 115.8605 recovered     0      Q1
## 5717 2020-03-20 Australia -31.9505 115.8605 recovered     0      Q1
## 5718 2020-03-21 Australia -31.9505 115.8605 recovered     0      Q1
## 5719 2020-03-22 Australia -31.9505 115.8605 recovered     0      Q1
## 5720 2020-03-23 Australia -31.9505 115.8605 recovered     0      Q1
## 5721 2020-03-24 Australia -31.9505 115.8605 recovered     0      Q1
## 5722 2020-03-25 Australia -31.9505 115.8605 recovered     1      Q1
## 5723 2020-03-26 Australia -31.9505 115.8605 recovered     0      Q1
## 5724 2020-03-27 Australia -31.9505 115.8605 recovered     0      Q1
## 5725 2020-03-28 Australia -31.9505 115.8605 recovered    27      Q1
## 5726 2020-03-29 Australia -31.9505 115.8605 recovered     0      Q1
## 5727 2020-03-30 Australia -31.9505 115.8605 recovered    13      Q1
## 5728 2020-03-31 Australia -31.9505 115.8605 recovered     0      Q1
# Cases type with total count in Australia
covidAUS %>% group_by(type) %>% 
  summarise(Mean = mean(cases, na.rm = TRUE),
                        Cases = sum(cases, na.rm = TRUE))
## # A tibble: 3 x 3
##   type        Mean Cases
##   <fct>      <dbl> <dbl>
## 1 confirmed 13.7   27059
## 2 death      0.438   862
## 3 recovered 12.4   24497
# top cases in each quarter by type in Australia. Lowest is 0
covidAUS %>% select(date, quarter, type, cases) %>% 
  group_by(type, quarter) %>% 
  top_n(1, cases)
## # A tibble: 10 x 4
## # Groups:   type, quarter [9]
##    date       quarter type      cases
##    <date>     <chr>   <fct>     <dbl>
##  1 2020-03-30 Q1      confirmed   241
##  2 2020-04-01 Q2      confirmed   150
##  3 2020-08-04 Q3      confirmed   700
##  4 2020-04-23 Q2      death         5
##  5 2020-04-28 Q2      death         5
##  6 2020-03-26 Q1      death         3
##  7 2020-09-03 Q3      death        59
##  8 2020-04-17 Q2      recovered  1375
##  9 2020-03-31 Q1      recovered   100
## 10 2020-08-20 Q3      recovered  2605
# Top countries with cases 
#---- Wider format
covidW <- covid %>% 
  select(country, lat, long, type, cases) %>% 
  group_by(country, lat, long, type) %>% 
  summarise(cases = sum(cases)) %>% 
  pivot_wider(names_from = type,
              values_from = cases) %>% 
  mutate(active = confirmed - death - recovered) %>% 
  arrange(-active) 
  
# Using pivot wider brings NANs. Removing those rows
sapply(covidW, function(x) sum(is.na(x)))
##   country       lat      long confirmed     death recovered    active 
##         0         0         0        29        29        41        69
covidW <- covidW[complete.cases(covidW), ]

#---long format
covidL <- 
  covidW %>% 
  pivot_longer(cols = confirmed:active, 
               names_to = "type", 
               values_to = "cases")

# Total cases past 24 hours (Global)
covid %>% 
  filter(date == max(date)) %>%
  select(country, type, cases) %>%
  group_by(country, type) %>%
  summarise(total_cases = sum(cases)) %>%
  pivot_wider(names_from = type,
              values_from = total_cases) %>% 
  arrange(-confirmed)
## # A tibble: 188 x 4
## # Groups:   country [188]
##    country        confirmed death recovered
##    <fct>              <dbl> <dbl>     <dbl>
##  1 India              83347  1085     89746
##  2 US                 37330  1098     23297
##  3 Argentina          12625   424      8258
##  4 Israel             11316    40      4212
##  5 Spain              11289   130         0
##  6 Peru                7651   199     28652
##  7 Colombia            6731   349     21377
##  8 Russia              6330   145      5679
##  9 United Kingdom      6187    37         9
## 10 Iraq                5055    72      3231
## # ... with 178 more rows
# total cases past 24 hours (Australia)
covidAUS %>% 
  filter(date == max(date)) %>%
  select(country, type, cases) %>%
  group_by(type) %>%
  summarise(total_cases = sum(cases)) %>%
  pivot_wider(names_from = type,
              values_from = total_cases) 
## # A tibble: 1 x 3
##   confirmed death recovered
##       <dbl> <dbl>     <dbl>
## 1         8     2       117
# New cases type for last 14 days in Australia. Also cumulative cases (sum of cases for each day)
covidVis <- covidAUS %>% 
  filter(date %in% tail(covidAUS$date, 14) ) %>% 
  select(date, type, cases) %>% 
  group_by(date, type) %>% 
  summarise(cases = sum(cases)) %>% 
  group_by(type) %>% 
  mutate(cumulative_cases = cumsum(cases)) 

# Growth rate
covidVis <- covidVis %>% 
  group_by(type) %>% 
  mutate(growth = ((cases - lag(cases))/lag(cases)) * 100)

# Total cases in Australia for past 14 days 
ggplot(covidVis, aes(fill=type, y=cases, x=date)) + 
  geom_bar(position="dodge", 
           stat="identity") +
  scale_color_manual(values = c("orange", "red", "green")) + 
  scale_fill_manual(values = c("orange", "red", "green")) + 
  scale_x_date(date_labels = "%b %d",
               breaks = covidVis$date) +
  theme(axis.text.x = element_text(angle = 30, hjust = 1)) +
  geom_text(
    aes(label = cases, group = type), 
    position = position_dodge(0.8),
    vjust = -0.3, size = 3.5
  ) + 
  ggtitle("New cases in Australia for past 14 days")

ggplot(covidVis, aes(x=date, y=cases, colour=type, group=type)) +
  geom_point() +
  geom_line() + 
  ggtitle("New cases in Australia for past 14 days")

# Daily cases shows how fast its growing but doesn't show how big it has grown overall. 
ggplot(covidVis, aes(x=date, y=cumulative_cases, colour=type, group=type)) +
  geom_line() + 
  ggtitle("Cumulative cases in Australia for past 14 days")

# Growth rate. The daily number of cases as a percentage of the total.
# This method is perhaps the most useful for demonstrating the effectiveness of social distancing and other public health measures for "flattening the curve".
# Negative growth rate indicates pandemic is under control
ggplot(covidVis, aes(x=date, y=growth, colour=type, group=type)) +
  geom_line() + 
  ggtitle("Growth rate in Australia for past 14 days")
## Warning: Removed 3 row(s) containing missing values (geom_path).

#####
# Recovery rate. 14.6 is max value and those are percentages
covidVIS <- covidAUS %>% 
  filter(date %in% tail(covidAUS$date, 14) ) %>% 
  select(date, type, cases) %>% 
  group_by(date, type) %>% 
  summarise(cases = sum(cases)) %>% 
  group_by(type) %>% 
  pivot_wider(names_from = type,
              values_from = cases) %>% 
  mutate(recover_rate = ((recovered / confirmed) /  14.6) * 100) %>% 
  mutate(recover_rate = if_else(is.na(recover_rate), 0, recover_rate))

ggplot(covidVIS, aes(x=date, y=recover_rate)) +
  geom_line() + 
  ggtitle("Recovery rate in Australia for past 14 days") +
  scale_x_date(date_labels = "%b %d",breaks = covidVis$date) +
  theme(axis.text.x = element_text(angle = 30, hjust = 1))

#----------------------------------------------------------------------

# changing the data frame as wider for interactive visualization
# Daily new cases
coviddaily <- covidVis %>% 
  select(date, type, cases) %>% 
  pivot_wider(names_from = type,
              values_from = cases) 

# Cumulative cases
# Don't use active now since we need to use whole dataset to show active cases.
covidcum <- covidVis %>% 
  select(date, type, cumulative_cases) %>% 
  pivot_wider(names_from = type,
              values_from = cumulative_cases) %>% 
  mutate(active = confirmed - death - recovered) %>% 
  mutate(active = cumsum(active))

# Growth rate
covidgrow <- covidVis %>% 
  select(date, type, growth) %>% 
  pivot_wider(names_from = type,
              values_from = growth)

###########################################
# Daily new cases interactive

confirmed_color <- "orange"
active_color <- "#1f77b4"
recovered_color <- "green"
death_color <- "red"

plot_ly(data = coviddaily, 
        x = ~ date,
        y = ~ confirmed,
        name = 'Confirmed', 
        fillcolor = confirmed_color,
        type = 'scatter',
        mode = 'none', 
        stackgroup = 'one') %>% 
  add_trace(y = ~ recovered,
                    name = "Recovered",
                    fillcolor = recovered_color) %>%
  add_trace(y = ~ death,
                    name = "Death",
                    fillcolor = death_color) %>% 
  layout(title = "Daily New Cases in Australia for past 14 days",
         yaxis = list(title = "Daily New Cases"),
         xaxis = list(title = "Date",
                      type = "date"),
         legend = list(x = 0.1, y = 0.9),
         hovermode = "compare")
# similarly goes for covidcum and covidgrow data frame

#-----------------------------------------------------------------------
# Map
# leaflet() %>% addTiles(). this shows static blank world map
pal <- colorFactor(c("orange", "blue", "red", "green"), domain = c("confirmed", "active", "death", "recovered"))

# adding log cases for radius purpose and removing NaNs
covidL <- covidL %>% 
  mutate(log_cases = 2 * log(cases))
## Warning in log(cases): NaNs produced
## Warning in log(cases): NaNs produced

## Warning in log(cases): NaNs produced

## Warning in log(cases): NaNs produced

## Warning in log(cases): NaNs produced
covidL <- covidL[complete.cases(covidL), ]

# Split act as 3 data frames for 3 types
covidL.split <- covidL %>% 
  split(covidL$type)

leaflet() %>% addTiles() %>% 
  addProviderTiles(providers$CartoDB.Positron) 
# ##
# Iterate in foor loop code doesnt work
# names(covidL.split) %>%
#   purrr::walk( function(covidL) {
#     world <<- world %>%
#       addCircleMarkers(data = covidL.split[[covidL]], lat = ~lat, lng = ~long,
#                        color = ~pal(type),
#                        stroke = FALSE,
#                        fillOpacity = 0.5,
#                        radius = case_when(
#                          covidL$type == "active" ~ 6,
#                          covidL$type == "death" ~ 2,
#                          covidL$type == "recovered" ~ 4,
#                          covidL$type == "confirmed" ~ 8
#                        ),
#                        group = covidL,
#                        clusterOptions = markerClusterOptions(removeOutsideVisibleBounds = F),
#                        labelOptions = labelOptions(noHide = F,
#                                                    direction = 'auto'))
#   })
# #####


groupI <- names(covidL.split)
leaflet() %>% addTiles() %>% addProviderTiles(providers$CartoDB.Positron) %>% 
  addCircleMarkers(data = covidL.split[[1]], lat = ~lat, lng = ~long,
                   color = active_color,
                   stroke = FALSE,
                   fillOpacity = 0.5,
                   radius = ~log_cases,
                   popup = paste0("Country: ", covidL.split[[1]]$country,
                                  "</br>Type: ", covidL.split[[1]]$type,
                                  "</br>Cases: ", covidL.split[[1]]$cases),
                   group = groupI[1],
                   labelOptions = labelOptions(noHide = F,
                                               direction = 'auto')) %>%
  addCircleMarkers(data = covidL.split[[2]], lat = ~lat, lng = ~long,
                   color = confirmed_color,
                   stroke = FALSE,
                   fillOpacity = 0.5,
                   radius = ~log_cases,
                   popup = paste0("Country: ", covidL.split[[2]]$country,
                                  "</br>Type: ", covidL.split[[2]]$type,
                                  "</br>Cases: ", covidL.split[[2]]$cases),
                   group = groupI[2],
                   labelOptions = labelOptions(noHide = F,
                                               direction = 'auto')) %>%
  addCircleMarkers(data = covidL.split[[3]], lat = ~lat, lng = ~long,
                   color = death_color,
                   stroke = FALSE,
                   fillOpacity = 0.5,
                   radius = ~log_cases,
                   popup = paste0("Country: ", covidL.split[[3]]$country,
                                  "</br>Type: ", covidL.split[[3]]$type,
                                  "</br>Cases: ", covidL.split[[3]]$cases),
                   group = groupI[3],
                   labelOptions = labelOptions(noHide = F,
                                               direction = 'auto')) %>%
  addCircleMarkers(data = covidL.split[[4]], lat = ~lat, lng = ~long,
                   color = recovered_color,
                   stroke = FALSE,
                   fillOpacity = 0.5,
                   radius = ~log_cases,
                   popup = paste0("Country: ", covidL.split[[4]]$country,
                                  "</br>Type: ", covidL.split[[4]]$type,
                                  "</br>Cases: ", covidL.split[[4]]$cases),
                   group = groupI[4],
                   labelOptions = labelOptions(noHide = F,
                                               direction = 'auto')) %>%
  addLayersControl(overlayGroups = names(covidL.split),
                   options = layersControlOptions(collapsed = FALSE))
# ####
# ## 

#################################################################

# top 5 countries with most active cases
covCountry <- covidW %>% 
  ungroup() %>% 
  top_n(5, active)

covCountry
## # A tibble: 5 x 7
##   country          lat    long confirmed  death recovered  active
##   <fct>          <dbl>   <dbl>     <dbl>  <dbl>     <dbl>   <dbl>
## 1 US              40   -100      6933548 201884   2672702 4058962
## 2 India           20.6   79.0    5646010  90021   4587613  968376
## 3 Brazil         -14.2  -51.9    4591364 138105   4046827  406432
## 4 France          46.2    2.21    494189  31506     82288  380395
## 5 United Kingdom  55.4   -3.44    409729  41862       344  367523
# Extract those top 5 country names 
countnames <- covCountry$country

# Contains top 5 countries with their daily cases
coworld <- covid %>% 
  select(date, country, type, cases) %>% 
  group_by(date, country, type) %>% 
  summarise(cases = sum(cases)) %>% 
  pivot_wider(names_from = type,
              values_from = cases) %>% 
  mutate(active = confirmed - death - recovered) %>% 
  filter(country %in% countnames)  %>% 
  arrange(date) 

# Now considering top 5 countries with their daily cases for past 14 days
tailWorld <- coworld %>% 
  
  tail(70, date) %>% 
  select(date, country, confirmed) %>% 
  pivot_wider(names_from = country, 
              values_from = confirmed)

# Daily Confirmed Cases in Top 5 Countries for past 14 days (Log scale)
plot_ly(data = tailWorld, 
        x = ~ date,
        y = ~ US,
        name = 'US', 
        mode = 'lines+markers', 
        type = 'scatter',
        stackgroup = 'one') %>% 
  add_trace(y = ~ India,
            name = "India",
            mode = 'lines+markers') %>%
  add_trace(y = ~ Brazil,
            name = "Brazil",
            mode = 'lines+markers') %>% 
  add_trace(y = ~ France,
            name = "France",
            mode = 'lines+markers') %>%
  add_trace(y = ~ `United Kingdom`,
            name = "United Kingdom",
            mode = 'lines+markers') %>%
  layout(title = "Daily Confirmed Cases in Top 5 Countries for past 14 days (Log scale)",
         yaxis = list(title = "Daily Confirmed Cases",
                      type = "log"),
         xaxis = list(title = "Date",
                      type = "date"),
         legend = list(x = 0.1, y = 0.9),
         hovermode = "compare")